Solved

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

Posted on 2013-12-23
6
221 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
  • 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
Gigs: Get Your Project Delivered by an Expert

Select from 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.

 
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 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

785 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