Help ISNA

[Taka83]

Hi all I would appreciate some advice on the formula below, more specifically how to get it return the word "Finished" if the cell contains a date rather than N/A. Currently it it returns a blank cell if N/A is in the cell (which I want) but the contents of the cell if it is filled (a date in this instance). If the cell is filled I want the formula to return the word "Finished"

IF(ISNA(VLOOKUP( )),"",VLOOKUP( ))

Any help would be much appreciated.

 

[Michael M]

Try

=IF(ISNUMBER(VLOOKUP()),"Finished","")

 

[Taka83]

How do I write that into my current formula, or will that achieve what I want as a stand alone?

I still want N/A to be blanked.

Sorry for my ignorance.

 

[Michael M]

Have you tried it as is ?
Works ok with my data

 

[Taka83]

Worked a treat, thank you.

Looks like I was approaching the formula from the wrong end!