Index Match for exact match

ssblue
ssblue used Ask the Experts™
on
Excel Index formula

I am using the following formula but it is not looking at exact matches.

=IFERROR(INDEX(Sheet2!B:B,MATCH($B2,Sheet2!A:A),0),"Not Found")

How can I make sure it looks for an exact match
Index-issue.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Developer
Commented:
Use the optional match type parameter of match

=MATCH (lookup_value, lookup_array, [match_type])

E.g.

=IFERROR(INDEX(Sheet2!B:B,MATCH($B2,Sheet2!A:A,0),0),"Not Found")
ssblueCoordinator

Author

Commented:
Thanks for the info and explanation.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial