Index, match between 2 sheets

[trosasco23]

Hello,

I need to do an index match formula to grab info from one sheet and match it with info from another sheet. Basically my formula should read:

if the Employee name (column E) from the Entry Tab is also in Test tab in (Column B), add the Document # from (Column I) in the test tab.. if not blank. It seems simple enough but I can't get it to work for me.

I'm planning on adding the formula in column G in the Entry Tab.


Thank you for anyone that will help.

[Pete_UK]

There are no matches in your sample file, so you won't see anything with this formula in G2:

=IFERROR(INDEX(TEST!$I:$I,MATCH(B2,TEST!$A:$A,0)),"")

or with this one:

=IFERROR(INDEX(TEST!$I:$I,MATCH(E2,TEST!$B:$B,0)),"")

Hope this helps.

Pete

[trosasco23]

With a little tweaking that actually worked. When I changed the formula to grab the employee ID number instead of the name it worked. I did have to change the ID number to "number" since it was stored by text. Thanks as always. You must love this stuff.