M
mastermind
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
=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