remove "#N/A" as a return value

[TK]

Hi:
=VLOOKUP(K46,$A$1:$E$10,5,0)
returns #N/A if k46 is empty

I tried various if statements in the following format.
to return an empty cell without success.

=IF(k46 = "","",=VLOOKUP(K46,$A$1:$E$10,5,0))

Any help will be greatly appreciated.

Thanks
TK

 

[Nitin Harkawat]

Use
=IF(ISNA(VLOOKUP(K46,$A$1:$E$10,5,0)),"",VLOOKUP(K46,$A$1:$E$10,5,0))

 

[TK]

Thanks Nitin

that hooked me right up

TK

Use
=IF(ISNA(VLOOKUP(K46,$A$1:$E$10,5,0)),"",VLOOKUP(K46,$A$1:$E$10,5,0))