View Single Post
  #1   Report Post  
RaPiDfIrE
 
Posts: n/a
Default how do i create a lookup

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)