You're missing the value_if_true argument for when ISNA is true.

Try this:

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

A possible alternative:

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

If you're using Excel 2007:

=IFERROR(VLOOKUP($A2,Specialists!$A$2:$E$93,2,0)," ")

--
Biff
Microsoft Excel MVP


"Picman" wrote in message
...
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