VLOOKUP-If cell is empty display text

[nigelog]

Hi
I have tried ISNA but could'nt get result needed. In a range lookup =VLOOKUP(E7,DETAILS,3,FALSE) I would like the cell to display "DATA NOT AVAILABLE" if the cell if empty(at the moment it displays a zero), and display the content of the cell if there is an entry in the cell. How do I change the formula to do this? Any assistance appreciated. gds Nigel

[EdMac]

Maybe

=if(VLOOKUP(E7,DETAILS,3,FALSE)="","No data available",VLOOKUP(E7,DETAILS,3,FALSE))

[nigelog]

EdMac, many thanks for your prompt reply, much appreciated and does exactly what I needed. Rgds Nigel

[EdMac]

You're welcome - thanks for the feedback.