Solved

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

Posted on 2013-12-23
6
219 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now