IF ISNA

=IF(R5=S5,"Sedol Match","")

Hi,

Can someone convert that to an ISNA so i dont get the #N/A error, i would just like a blank

Thanks
Seamus
Microsoft Excel

Last Comment
Seamus2626
barry houdini

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Seamus2626

Thanks Barry,
Seamus
Seamus2626

hey Barry, i tried the above on a vlookup and got an error,

=IF(ISNA(VLOOKUP(S5,\$R:\$R,1,0)),"",IF(VLOOKUP(S5,\$R:\$R,1,0)),"Sedol Match",""))

Can up im see where im messing that up?

Thanks
Seamus
Saqib Husain

Try

=IF(ISERR(VLOOKUP(S5,\$R:\$R,1,0)),"",IF(VLOOKUP(S5,\$R:\$R,1,0)),"Sedol Match",""))
Saqib Husain

or

=IF(ISNA(VLOOKUP(S5,\$R:\$R,1,0)),"",IF(VLOOKUP(S5,\$R:\$R,1,0))>0,"Sedol Match",""))
Seamus2626

Thanks ssaqibh!!

Much appreciated

Seamus
Saqib Husain

Which one? or both?
Seamus2626

Sorry, second one!
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts

TRUSTED BY