Hello all!

I've been struggling to solve this issue. I apologize in advance, my excel skills are a bit weaker than I thought.

Table 1 has Customer Number, each issue with the customer's file, and an indicator for whether the issue is pending (PN). Table 2 has customer numbers, each issue with the customer's file, and the date the issue was corrected.

I need to compare table 1 to table 2, to check if issues showing as pending have a resolved date. The goal is to have a formula that pulls the customer number and doc from table 1, then searches table 2 for the row that has that same customer number and doc. If found, the formula returns the date.

A short example of the tables are below (1 on left, 2 on right). Normally I keep them on separate tabs of the same workbook.

8-27-2015 11-34-23 AM.png

Thank you for any/all help!