| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP tweaks needed please!
I need to correct the VLOOKUP formula below, its not quite right with the
named range. The workbook is called 'mel test' on sheet 1 and contains a named range 'name'... =VLOOKUP($D2,[G\[mel test.xls]name",2,FALSE) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP tweaks needed please!
I just tested this =VLOOKUP(3,'20061101.xls'!myrange,2,0) If no spaces in the name the ' ' should not be necessary -- Don Guillett SalesAid Software "Meltad" wrote in message ... I need to correct the VLOOKUP formula below, its not quite right with the named range. The workbook is called 'mel test' on sheet 1 and contains a named range 'name'... =VLOOKUP($D2,[G\[mel test.xls]name",2,FALSE) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP tweaks needed please!
See if =VLOOKUP($D2,'G:\mel test.xls'!name,2,FALSE) will work.
"Meltad" wrote: I need to correct the VLOOKUP formula below, its not quite right with the named range. The workbook is called 'mel test' on sheet 1 and contains a named range 'name'... =VLOOKUP($D2,[G\[mel test.xls]name",2,FALSE) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP tweaks needed please!
Thanks - this is much better! :-)
"bigwheel" wrote: See if =VLOOKUP($D2,'G:\mel test.xls'!name,2,FALSE) will work. "Meltad" wrote: I need to correct the VLOOKUP formula below, its not quite right with the named range. The workbook is called 'mel test' on sheet 1 and contains a named range 'name'... =VLOOKUP($D2,[G\[mel test.xls]name",2,FALSE) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP tweaks needed please!
I'd open that other workbook and build the formula by typing:
=vlookup($d2, then use the mouse to point at that range then finish up with the ,2,false) Excel will get the syntax right. Meltad wrote: I need to correct the VLOOKUP formula below, its not quite right with the named range. The workbook is called 'mel test' on sheet 1 and contains a named range 'name'... =VLOOKUP($D2,[G\[mel test.xls]name",2,FALSE) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Help Needed | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Convert VLOOKUP to absolute cell reference | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Hybrid Mode
