Look up Values using more than 1 criteria and return readings

[Nairobi Nice]

Hi

I have 2 tables that I need to match 2 components of each table, so as to get a corresponding match.
As in the example, Table 2 lacks data on third column "Brand_Price".
The data exists in Table 1, but table 1 may be:

1. Jumbled up
2. be larger than table 2 (as this example)
3. Be smaller

Hence I would like a return on 3rd column of table 2 to be, only when the 1st and 2nd cell in the row match

I have 2 tabs in my example, the problem as is, and what it should be, indicating from which rows/cells Table 2 has returned from table 1

Many Thanks

[soberguy]

Enter as array formula with Ctrl+Shift+Enter:
=INDEX(A3:C30,MATCH(E3&F3,A3:A30&B3:B30,0),3)

[FDibbins]

Or this non-array formula...
=INDEX($C$3:$C$30,MATCH(E3&F3,INDEX($A$3:$A$30&$B$3:$B$30,0),0))
copied down

[soberguy]

FDibbins, curious if I may, are there preferences as to when one should or should not use an array? I do like your take on it, though. Very nice.

[Nairobi Nice]

@Fdibbins - Worked like a charm, thanks
@Soberguy - Somethings off, returns #VALUE - Maybe I misunderstand the array enter instruction. It would be good to know 2 ways to do this

[FDibbins]

FDibbins, curious if I may, are there preferences as to when one should or should not use an array? I do like your take on it, though. Very nice.

array's can become resource-heavy, probably wont make any difference in this example, but if used a lot, they can slow a file down.
Also, never a good idea to use full-column ranges with arrays (not that we were, just saying)

[soberguy]

Arrays are confirmed with pressing Control AND Shift AND Enter at the same time. So while in the formula bar at the top, I usually hit and hold control, then shift, then hit the enter key.

[Nairobi Nice]

@Soberguy ... Works. Many Thanks

[soberguy]

Thanks. Going to keep that tidbit stored and try to use your non-array with some of my large data sets.