looks up information from a named range in another worksheet

Try something like this:

=IF(A15="","",VLOOKUP(A15,named_range,column_index _number,0))

--
Biff
Microsoft Excel MVP


"Jo" wrote in message
...
I want to enter a function that in cell B15 will display an empty cell if
A15
is blank but otherwise looks up information from a named range in another
worksheet. I've got as far as clicking into B15 and putting in
=if(A15,"","",=vlookup(

The range is on a worksheet called "items" as follows:
A3 B3 C3 D3 E3 F3
D001 Dijon Wall Unit Vanilla Gloss 300 £137.99

Jo