| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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) |
|
#2
|
|||
|
|||
|
<!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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
| Create Total based on lookup value | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
