how do i create a lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a mileage sheet that i want to be able to type in a destination name
(eg. in cell B4) and it looks at data elsewhere on the worksheet and matches
the place name (eg. in cell range F4:F11) and the inserts the mileage amount
from another cell range (eg. cell range G4:G11) and then inserts this second
value into another cell (eg. C4)
 
RaPiDfIrE wrote:

i have a mileage sheet that i want to be able to type in a destination name (eg. in cell B4) and it looks at data elsewhere on the worksheet and matches the place name (eg. in cell range F4:F11) and the inserts the mileage amount from another cell range (eg. cell range G4:G11) and then inserts this second value into another cell (eg. C4)


Try using:

     [C4] = VLOOKUP(B4,F4:G11,2)

Bill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
Returning last number(time) in a row of cells 4
Challenging the GOAL SEEK function within a bonus scheme 6
Matching a List Containing Redundant Values 1
How do I get an inserted symbol to show in another worksheet? 1
Can I add to a cell value without manual calculation? 1
MACRO COLUMNS, SKIP ROWS 6

Back
Top