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)

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)

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)

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)

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