Standard VLOOKUP but need to replace #N/A with blank

[coffee11]

Hi,

How do you change this VLOOKUP so that if the result is #N/A, and if the field is blank, the result will be either "no" or a blank field?

=VLOOKUP(A8,'PROCESS Trk'!$C$9:$O$53,13,FALSE)

 

[Brian from Maui]

Re: Does anybody know how to VLOOKUP dates without returning

the empty fields in the VLOOKUP as 00/01/1900 (I want them to be empty)

if you mean there are empty fields in your lookup table, enter ="" in the empty cells (courtesy of Mark W.)

 

[Grimbo2k]

Dont know if you still need this but another solution for you:

=if(iserror(VLOOKUP(A8,'PROCESS Trk'!$C$9:$O$53,13,FALSE)),"",VLOOKUP(A8,'PROCESS Trk'!$C$9:$O$53,13,FALSE))

Cheers
Grimbo

 

[Brian from Maui]

Dont know if you still need this but another solution for you:

=if(iserror(VLOOKUP(A8,'PROCESS Trk'!$C$9:$O$53,13,FALSE)),"",VLOOKUP(A8,'PROCESS Trk'!$C$9:$O$53,13,FALSE))

Cheers
Grimbo

http://www.mrexcel.com/board2/viewtopic.php?t=62102