asked on 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
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
Microsoft Excel
Last Comment
James Murrell
Can post your worksheet here?
ASKER
as requested
F1-test.xlsx
F1-test.xlsx
Here you go!
F1-testr1.xlsx
F1-testr1.xlsx
ASKER
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
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
would love to give more tha A wow thanks..... great service: guess there may be more later