Jo,

Remove the =vlookup and place VLOOKUP, also place the qualifier on the
variable for your IF, where A15 = "".

The IF format is:
IF(<qualifying response,<if true,<if false)

The VLOOKUP format is:
VLOOKUP(<value,<range,<column number,<true/false)

So:
=if(A15="","",vlookup(.....))

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Jo" wrote:

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