[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2013-12-23
6
Medium Priority
?
241 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

873 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