Loading...

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

8,947 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Mar 19, 2012

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.

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...