2010 - Need to match data and return specific cell value - SUMIF? MATCH? INDEX? HELP!

Hi All,

I've been working on this forever and I just can't figure it out! I have 2 spreadsheets, need to match multiple cells and return a value based on the match. In the attached sample, I need to...

Find a match for cells B1, J1, and K1 from tab 1 to cells in column A, C, and B from tab 2. When they all match, I need it to return the contents of the cell in column D.

I am needing the confirmation number found on tab 2 to be put next to it's coinciding information on tab 1 but I can't do a standard vlookup since there could be multiple entries for each employee number, amount and account on tab 2.

Any help is greatly appreciated, I'm not getting anywhere on my own...

Adriane

Are you sure you don't mean columns G H and I from Tab 1, match up to A C and B respectively on Tab 2 ?
And will there only be 1 match of all 3 criteria on Tab 2 ?

Try
=SUMPRODUCT(--('Tab 2'!A$1:A$10000='Tab 1'!G2),--('Tab 2'!C$1:C$10000='Tab 1'!H2),--('Tab 2'!B$1:B$10000='Tab 1'!I2+0),'Tab 2'!D$1:D$10000)

Yes, sorry, it should have been G, H, and I from Tab 1. I thought I had deleted all the extra columns from my actual spreadsheet so it wasn't so cluttered with extra information when I posted it on here. I will try both of the above (have to change a bit to accommodate the actual cell numbers). Wish me luck, thanks so much for responding, and I'll let you know how it goes!