If this is returning error return blank and if not vlookup...

(all in one line)

=IF(
ISNA(VLOOKUP($A2,Specialists!$A$2:$E$93,2,FALSE)),
"",
VLOOKUP($A2,Specialists!$A$2:$E$93,2,FALSE))

If this post helps click Yes
---------------
Jacob Skaria


"Picman" wrote:

i wrote this ISNA Formula

=IF(ISNA(VLOOKUP($A2,Specialists!$A$2:$E$93,2,FALS E)),VLOOKUP($A2,Specialists!$A$2:$E$93,2,FALSE))

and it is returning "False" instead of value. Can anyone help