| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP Formula using variable for lookup_value
I have a cell format search criteria over a specified column range. When the
criteria is satified, I need to enter a formula using VLOOKUP in an adjacent column that uses the value in the cell that satisfied my format search criteria as the lookup value. I used the formaul: "=VLOOKUP(Target,'C:\Documents and Settings[SummaryByProject(111005).xls]Current'!$B$1:$D$585,2,FALSE)" , where I tried to define Target as the cell that satisfied teh search criteria, but it does not work. I'd apprecaite any help you can give on this Thanks -- Los |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP on partial lookup_value | Excel Discussion (Misc queries) | |||
| vlookup lookup_value text | Excel Worksheet Functions | |||
| vlookup lookup_value | Excel Worksheet Functions | |||
| Vlookup(lookup_value) | Excel Worksheet Functions | |||
| vlookup:same lookup_value, different returns | Excel Worksheet Functions | |||
Threaded Mode
