ExcelBanter - how do i create a lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i create a lookup (https://www.excelbanter.com/excel-discussion-misc-queries/25566-how-do-i-create-lookup.html)

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)

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
<html
<head
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type"
</head
<body bgcolor="#ffffff" text="#000000"
RaPiDfIrE wrote:
<blockquote "
type="cite"
<pre wrap=""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)
</pre
</blockquote
<font face="Arial"<br
Try using:<br
<br
Â*Â*Â*Â* [C4] = VLOOKUP(B4,F4:G11,2)<br
<br
Bill<br
</font
</body
</html