Index Match

https://www.excel-easy.com/examples/index-match.html
Match Index Index and Match Two way Lookup Case sensitive Lookup Left Lookup Two column Lookup Closest Match Xlookup Use INDEX and MATCH in Excel and impress your boss Instead of using VLOOKUP use INDEX and MATCH To perform advanced lookups you ll need INDEX and MATCH Match

https://exceljet.net/formulas/index-and-match-with-multiple-criteria
To lookup values with INDEX and MATCH using multiple criteria you can use an array formula In the example shown the formula in H8 is INDEX E5 E11 MATCH 1 H5 B5 B11 H6 C5 C11 H7 D5 D11 0 The result is 17 00 the Price of a Large Red T shirt

https://corporatefinanceinstitute.com/resources/...
What is INDEX MATCH in Excel The INDEX MATCH Formula is the combination of two functions in Excel INDEX and MATCH INDEX returns the value of a cell in a table based on the column and row number MATCH returns the position of a cell in a row or column

https://exceljet.net/formulas/index-and-match-exact-match
The trick is to give INDEX all 3 columns in the range C5 E16 then specify zero 0 for the row number INDEX C5 E16 MATCH H4 B5 B16 0 0 Providing zero for the column num argument will cause INDEX to return an entire row of data With Toy Story in cell H4 we get back a horizontal array of values like this

https://www.howtogeek.com/793270/index-and-match-in-excel
INDEX and MATCH Function Basics To use these functions together it s important to understand their purpose and structure The syntax for INDEX in Array Form is INDEX array row number column number with the first two arguments required and the third optional INDEX looks up a position and returns its value

https://support.microsoft.com/en-us/office/look-up...
The VLOOKUP and HLOOKUP functions together with INDEX and MATCH are some of the most useful functions in Excel Note The Lookup Wizard feature is no longer available in Excel Here s an example of how to use VLOOKUP VLOOKUP B2 C2 E7 3 TRUE In this example B2 is the first argument an element of data that the function needs to work

https://www.excelcampus.com/functions/index-match-formula
The INDEX MATCH functions look up and return the value of a cell in a selected array using 1 or 2 reference values INDEX MATCH is like VLOOKUP but INDEX MATCH is more robust and flexible

https://www.lifewire.com/index-match-functions-excel-4843446
What Are the INDEX and MATCH Functions INDEX and MATCH are Excel lookup While they are two entirely separate functions that can be used on their own they can also be combined to create advanced formulas The INDEX function returns a value or the reference to a value from within a particular selection

https://www.wikihow.com/Use-Index-Match
The syntax is as follows INDEX array MATCH lookup value lookup array match type MATCH lookup value lookup array match type Recall back to the original INDEX syntax your two nested MATCH functions are acting like the row and column numbers to create a two way lookup