View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo Jo is offline
external usenet poster
 
Posts: 113
Default lookup within an IF formula

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