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

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
LVL 31
James MurrellProduct SpecialistAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
andrew_manConnect With a Mentor Commented:
Okay, ic
F1-testr1.xlsx
0
 
andrew_manCommented:
Can post your worksheet here?
0
 
James MurrellProduct SpecialistAuthor Commented:
as requested
F1-test.xlsx
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
andrew_manCommented:
Here you go!
F1-testr1.xlsx
0
 
James MurrellProduct SpecialistAuthor Commented:
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
 
James MurrellProduct SpecialistAuthor Commented:
would love to give more tha A wow thanks..... great service: guess there may be more later
0
All Courses

From novice to tech pro — start learning today.