vlookup - n/a and blank

[LAURAAB1984]

Hi,

I have the following formula;

=VLOOKUP($A$2:$A$3000,'Q:\Curriculum Services\Advisor\EHCP Annual Review\[Master Annual Reviews.xlsx]Master'!$A$2:$U$670,11,FALSE)

The result of this formula is finding a date and returning it for those students that are on the Master Annual Review spreadsheet, which it does if they have one in column 11... If they aren't on the spreadsheet it returns N/A - so far so good.... BUT when the student is on the Master Review Spreadsheet but without a date (i.e. a blank cell) it is returning nonsense (00/01/1900).

I really want it to return a date if there is one and an N/A if they aren't on the spreadsheet OR if they are but have a blank...

Can anyone help please?

Much appreciated!

Thank you.

 

[Blochand]

It will not be pretty, but a simple IF could do it:


IF(vlookup path=0,"#N/A",vlookup path)


//Blochand

 

[LAURAAB1984]

It will not be pretty, but a simple IF could do it:


IF(vlookup path=0,"#N/A",vlookup path)


//Blochand

Beautiful - thank you!!

 

[Tlund]

This helped me with my problem this morning, thank you