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.