?
Solved

how to lookup if cell says one thing for it to pick another cell

Posted on 2013-12-23
6
Medium Priority
?
230 Views
Last Modified: 2013-12-23
Sorry not great at excel (used to be but its been a while since I have played with it)


i have fours sheets.
sheet1 = has
Submission Date      E-mail      First Name      Last Name      Age      Driver 1      Driver 2      Driver 3      Team 1      Team 2

sheet 2 has
Driver      Cost

sheet3 has
Team_Name      Cost


what i need to do on sheet 4 is if sheet1 driver1 = 25 (for example) for it to lookup sheet 2 cost and return driver cell

hope this makes sense
0
Comment
Question by:James Murrell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:andrew_man
ID: 39735830
Can post your worksheet here?
0
 
LVL 31

Author Comment

by:James Murrell
ID: 39735833
as requested
F1-test.xlsx
0
 
LVL 4

Expert Comment

by:andrew_man
ID: 39735840
Here you go!
F1-testr1.xlsx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 31

Author Comment

by:James Murrell
ID: 39735845
wow quick- but hate to say it not exactly right.. my fault i guess

on Submissions it says driver 1

need

Teams to lookup on DRIVERS Cost - who is the driver

so if 25 is on Submissions f2 then teams c2 shows Sebastian Vettel
 whom is 25 in drivers cost


hope that makes it clearer
0
 
LVL 4

Accepted Solution

by:
andrew_man earned 2000 total points
ID: 39735852
Okay, ic
F1-testr1.xlsx
0
 
LVL 31

Author Closing Comment

by:James Murrell
ID: 39735855
would love to give more tha A wow thanks..... great service: guess there may be more later
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question