I thought I was doing the formula correctly using index-match but it's giving the wrong answer. I also tried a VLOOKUP, MATCH, and LOOKUP and still not getting the correct answer. I have a range with ID's and then names. In another column, I just have ID's not in any order. I am trying to match the names with the ID's from the first range. It seems pretty straight forward, but it keeps giving me incorrect names. I have searched with all of the above formulas, and I am pretty sure I did it right, but I know I am missing something. Thank you in advance for the help!
,0 at the end of MATCH to find an exact match. If not it will find a similar one. If not you can change MATCH with XMATCH whose option by default is exact match!