Hi,


1. N/A - If means it didn't find and exact match for A2 in columa A on the
second sheet.

2. If you are going to use ISNA Change the formula to

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


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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