ISNA Formula returning "False" instead of value
Thanks guys, all of your suggestions worked. Once again this is the place for
answers, great job!!!
"Shane Devenshire" wrote:
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
|