Index match match not using second set of match criteria

[ajw34229]

What I'm trying to do is pull the vendor name from the raw data file by matching both the item number and low location name, but I can't seem to get the second set of match criteria to work. Here is the existing formula that I have in place: =INDEX('Raw Data Bill Only'!$K$7:$K$7642,MATCH(A7,'Raw Data Bill Only'!$B$7:$B$7642,MATCH(R7,'Raw Data Bill Only'!$J$7:$J$7642,0)))

Based on the data, the return vendor value should be "Online Packaging, Inc." as that matches both the 'item' and 'low location' criteria, but it returns "Champion Packaging & Distributing" instead.

Any help would be appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TAKE(FILTER('Raw Data Bill Only'!$K$7:$K$7642,(A7='Raw Data Bill Only'!$B$7:$B$7642)*(R7='Raw Data Bill Only'!$J$7:$J$7642)),1)

 

[ajw34229]

Hi & welcome to MrExcel.
How about

=TAKE(FILTER('Raw Data Bill Only'!$K$7:$K$7642,(A7='Raw Data Bill Only'!$B$7:$B$7642)*(R7='Raw Data Bill Only'!$J$7:$J$7642)),1)

This worked!!

Can you briefly explain what the TAKE/FILTER function does? I'll have to dig into that one further so I can understand it better. THANK YOU!!

 

[Fluff]

The filter returns all rows in col K that match the criteria & take will "take" the 1st of them.