Index/Match Formula Issue

Hello!

I'm beginning to work with Index/Match nested functions and I'm running into a problem with a few particular cases. In the attached document, LIV2172 and LIV2236 in the Summary tab are showing the wrong city in column B and I'm not sure why since they're using the same formula as the other 20 or so lines that are working. Can someone please tell me if my formula structure was wrong or if there's a better way to accomplish what I'm trying to do?

Thanks,

Nate

If you don't include the third (optional) parameter in a MATCH formula, then the function will not look for an exact match - it will match on a value that is less than or equal to the sought item. For this to work properly, the data in the match_range needs to be sorted, and I can see that yours isn't, so this can produce spurious results. The solution is to look for exact matches, which means changing expressions like this: MATCH(A17,Internships!A:A) to this: MATCH(A17,Internships!A:A,0).

The 0 could be replaced by FALSE, but I use it as it is quicker to type and means the same.

Hope this helps.

Pete

Worked perfectly. Thanks Pete!