Link to home
Start Free TrialLog in
Avatar of James Murrell
James MurrellFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of andrew_man
andrew_man
Flag of Hong Kong image

Can post your worksheet here?
Avatar of James Murrell

ASKER

as requested
F1-test.xlsx
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
ASKER CERTIFIED SOLUTION
Avatar of andrew_man
andrew_man
Flag of Hong Kong image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
would love to give more tha A wow thanks..... great service: guess there may be more later