VLookup with multiple matching columns

[Delta729]

Hi all,

I don't know if this is possible, but hopefully someone could help me out. I have two tables created from different data sets. The first is the total count confirmations that were processed for a month ("Counts" table). The
second is "Errors" table.


What I am attempting to do is pull in the "Confirmation Count" from the Counts table to the "Total Number of Accepted" if the "Reporting Month" & "Confirmation Type" & "Region or AOR" & "Vendor Name" from both tables match. Currently I'm dumping both sets of data into Access and the doing a match and then bringing it back over. This seems like a waste of time, but everything I've tried; I can't get to work. VLookup (nested), Index and match, no luck.

If anyone has any ideas, I'd be very greatful.

Just added an Excel file if this would be more clear.

[benishiryo]

hi Delta729, go to G2 & copy this into the formula bar:

Please Login or Register  to view this content.

press CTRL + SHIFT + ENTER to confirm

[Delta729]

wow... that worked perfectly. I tried this before and I think I was selecting the columns headers instead of A2, B2, etc...
Thank you very much.