I currently have this function in my spread sheet:

=IF(B17<"",VLOOKUP(B17,'Data Sheet'!$D$11:$E$60,2,FALSE),"")

Although the function works just fine, when the value of the second
cell is filled, it results to "#N/A" when it is blank. I would like
the function to display whatever the value is in the second cell
whether it is blank or filled. Does anyone know how to do this using
VLOOKUP, or possibly some other excel function? Any help would be
greatly appreciated. Thank you.

John

Is this what you are looking for?

=IF(ISNA(IF(B17<"",VLOOKUP(B17,'Data
Sheet'!$D$11:$E$60,2,FALSE),"")),"",IF(B17<"",VLO OKUP(B17,'Data
Sheet'!$D$11:$E$60,2,FALSE)))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"mastermind" wrote:

I currently have this function in my spread sheet:

=IF(B17<"",VLOOKUP(B17,'Data Sheet'!$D$11:$E$60,2,FALSE),"")

Although the function works just fine, when the value of the second
cell is filled, it results to "#N/A" when it is blank. I would like
the function to display whatever the value is in the second cell
whether it is blank or filled. Does anyone know how to do this using
VLOOKUP, or possibly some other excel function? Any help would be
greatly appreciated. Thank you.

John

That is exactly what I needed, thanks a bunch.