Trying to get an Index Match Formula to Work

Hi EE,

Excel query trying to use the Index/Match formula compare what values in Column A Match, Any column Values in Column D, see attached, with Column B showing the result 'Match', 'No Match'.

Any assistance is welcome.

Thank you.
ZackGeneral IT Goto GuyAsked:
Who is Participating?
Ryan ChongConnect With a Mentor Commented:
in B2, try :

=IF(ISERROR( MATCH(A2,$D$2:$D$100,0) ),"No Match", "Match")

Open in new window

drag this formula for the cells below it.

you no need to use Index function since you're not referring to a value based on the matched value.
ZackGeneral IT Goto GuyAuthor Commented:
Hi Ryan,

Thank you very much again for your assistance.
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.