Скачать или смотреть Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table

Download Excel Start File: https://people.highline.edu/mgirvin/Y...

Download workbook: http://people.highline.edu/mgirvin/Ex...
Reverse Lookup To Create Proper Data Set From Column Row Header Table (Tabular Setup):
1. 2007 method: Lookup numbers inside the table and return row headers (including duplicates) using INDEX, SMALL, IF, ROW, ROWS and IFERROR
2. 2007 method: Lookup numbers inside the table and return column headers (including duplicates) using INDEX, SMALL, IF, COLUMN, COUNTIF and IFERROR
3. 2007 method: Two way lookup for looking up numbers inside the table using VLOOKUP, MATCH and IFERROR
4. 2010 method: Lookup numbers inside the table and return row headers (including duplicates) using INDEX, AGGREGATE, IF, ROW, ROWS and IFERROR
5. 2010 method: Lookup numbers inside the table and return column headers (including duplicates) using INDEX, AGGREGATE, IF, COLUMN, COUNTIF and IFERROR
6. 2010 method: Two way lookup for looking up numbers inside the table using VLOOKUP, MATCH and IFERROR
7. 2007 method: Lookup numbers inside the table and return row headers (including duplicates) using INDEX, SMALL, IF, ROW, ROWS and IF with ROWS and COUNT functions
8. 2007 method: Lookup numbers inside the table and return column headers (including duplicates) using INDEX, SMALL, IF, COLUMN, COUNTIF and IF with ROWS and COUNT functions
9. 2007 method: Two way lookup for looking up numbers inside the table using VLOOKUP, MATCH and IF with ROWS and COUNT functions

Array Formula. Extract Records Data. Rearrange table with formula. Take Tabular table and re-create records for proper data set with extracting data array formula.