Thread: ISNA Formula returning "False" instead of value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Picman Picman is offline
external usenet poster
  
Posts: 70
Default ISNA Formula returning "False" instead of value
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
Reply With QuoteReply With Quote