Use the following formula:
=INDEX(Sheet2!$F$1:$F$100,MATCH(1,INDEX((Sheet2!$A$1:$A$100=A1)*(Sheet2!$B$1:$B$100=B1),),0))
Sheet 2 for reference
More Related Contents:
- VLOOKUP with multiple criteria returning values in one cell
- Vlookup using 2 columns to reference another
- Excel VLOOKUP where the key is not in the first column
- Comparing two columns, and returning a specific adjacent cell in Excel
- Excel – VLOOKUP vs. INDEX/MATCH – Which is better?
- SumIf using Excel VBA
- How can I call a macro which contains a loop but only run one iteration of that loop?
- Test or check if sheet exists
- How can I find last row that contains data in a specific column?
- How to turn a string formula into a “real” formula?
- Copy from one workbook and paste into another
- Read an Excel file directly from a R script
- Open Excel file for reading with VBA without display
- Last non-empty cell in a column
- Excel VBA App stops spontaneously with message “Code execution has been halted”
- How to remove all non alphanumeric characters from a string except period and space in excel?
- Retrieving the COM class factory for component failed
- How to clear memory to prevent “out of memory error” in excel vba?
- Assign on-click VBA function to a dynamically created button on Excel Userform
- Using a wildcard to open an excel workbook
- Fully reference a worksheet by codename
- OnTime for less than 1 second without becoming Unresponsive
- How to clear memory to prevent “out of memory error” in VBA?
- Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
- Extract Data from PDF and Add to Worksheet
- VBA editor auto-deletes spaces at the ends of lines
- Select entire column in table using Excel VBA
- Create folder path if does not exist (saving from VBA)
- Is it possible to see more than 65536 rows in Excel 2007? [closed]
- Concatenate multiple ranges using vba