Main Profile

At A Glance

Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm 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.
Length: 16:42

Contact

Questions about Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table

Want more info about Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question