how do i create a lookup

R

RaPiDfIrE

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)
 
G

Guest

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
 
Top