Forum Discussion
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 I...
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?