Index Match is pulling correctly and then starts duplicating wrong values in cell

SHELLSIE

Hello, I am trying to pull in the email address from a master contact list into a different contact list with pay rates. I am using this formula: =INDEX({EMAIL}, MATCH([Full Name]@row, {FULLNAME})) and initially it is pulling the correct email address to the correct individual, then further down the page it starts duplicating the same persons email address for the incorrect name and I can't figure out why.

Capture.JPG

Paul Newcome

Try a zero in the third portion of the MATCH function to indicate an exact match instead of just a close match.

=INDEX({EMAIL}, MATCH([Full Name]@row, {FULLNAME}, 0))

Scott Orsey

Hi,

You'll want to review the inputs for the MATCH function. As written, MATCH assumes that the values are entered alphabetically and in order. Instead, you likely want an EXACT match which doesn't require alphabetical order, so you'll need to add in the third argument with a "0" like this:

=INDEX({EMAIL}, MATCH([Full Name]@row, {FULLNAME},0))

Hope this helps

Be well

SHELLSIE

For some reason when I enter it with the 0 I get back this #NO MATCH

Jason Albrecht

Hi @SHELLSIE

I would check the Full Name row, to make sure there are not extra spaces " " after the name.

e.g.: "Jason " and "Jason" will not match, and yet it looks the same.

Paul Newcome

Double check that you do in fact have a match in the {Full Name} range based on [Full Name]@row. Are you able to provide some screenshots for further troubleshooting?