Index Match Formula

Hi Guys, does anyone know how to put an ISNA around this Index Match formula?

Who is Participating?
andrew_manConnect With a Mentor Commented:
barry houdiniConnect With a Mentor Commented:
I'd use the more normal construction (for your original formula)


or even


Then you can use IFERROR round either of those as andrew_man suggests, ie.


regards, barry
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.