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)