I am currently using a MATCH formula to look for an exact cell value (combination of numbers and characters) from a cell in a list of macro created hyperlinks on column A.
Ex: =MATCH(F2,A:A,0)
When it finds the cell value (exact value only, that's why I use 0), it tells me ONLY the row level in column A. When it can't find it, it returns the #N/A. How can I change the formula such that in place of returning a #N/A value, it simply gives me a blank?
You can use IFERROR function like this
=IFERROR(MATCH(F2,A:A,0),"")
Audere est facere
Formula:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks. That was exactly what I was looking for.
You're welcome.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks