Forum Discussion

marten casarez's avatar
marten casarez
Copper Contributor
Oct 16, 2018

INDEX MATCH MATCH #N/A Error

I have two separate worksheets in excel that I would like to merge together. I have one sheet that lists the amount an employee has in sales for any given day but this is displayed with an employee ID number and does not an employee name attached. I have a separate sheet that has the employee names with the id numbers. I would like to put the two sheets together by using the employee ID number to match up the information so that I may see the names of the employees next to the sales and not just the employee ID numbers. 

How may I perform this in excel? Thanks in advance. 

  • Marten, based on the subject of your post you tried INDEX/MATCH, that's correct way. But why do you have #N/A error it's hard to say without concrete data/formula. Perhaps you may provide small sample file to check?

Resources