Matching two columns....

[bcrockett101]

I will do my best to explain... I am pulling data from two databases via SQL --

In both data sets, there's a Date column, and Phone Extension column.

I need to look up values from data set one, and match them to data set two, to bring in the data from data set two, to marry the two.... hope this makes sense.

The attached PIC should help - the column highlighted yellow under data set two, is the data I need to marry to data set one, using the date and ext columns..

Example.JPG

[loginjmor]

Hi -

Are there any repeats? For example, two or more entries of the same date and same extension?

[bcrockett101]

No, there are not -

Date And Ext, will not be repeated for the same date anyway..

Example,

12/31/16 645 may be repeated on the line below, but under a different date.
01/01/17 645
01/02/17 645

Hope this makes sense.

[loginjmor]

I would try the following:
=INDEX($G$3:$G$5,SUMPRODUCT((A3=$E$3:$E$5)*(B3=$F$3:$F$5)*ROW())-2)

This assumes the data in your picture above starts at Cell A3 (the first date of Data Set 1). That's important because the ROW() function gives you the absolute row number where SUMPRODUCT determines both criteria match. INDEX uses the Relative row number starting at the top of the data set (in this case, INDEX treats Cell A3 as Row 1 of the data set), but ROW() will return the row of cell A3 as 3. So, to get SUMPRODUCT to return the Relative row number that makes sense to INDEX, I have to subtract 2 from ROW(). So, if your data actually starts in Cell G10, then I have to subtract 9 from ROW(). Make sense?

Hope this helps.