troubleshooting Question

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

Avatar of James Murrell
James MurrellFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
6 Comments1 Solution263 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros