Loading...

Excel Magic Trick 886: Two Way Lookup, List Names In Tabular Table (Row & Column Criteria)

6,411 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 23, 2012

Download workbook: http://people.highline.edu/mgirvin/Ex...
Two Way Lookup to List Names in Tabular Table with Criteria in Row and Column Headers. Create Tabular table with criteria in row and column headers from a proper data set with field names and records in rows. 2 Methods: Formula To Show Manager Names In Tabular Form From Proper Data Set
1. INDEX and MATCH functions with Joined "AND" Criteria as well as Mixed Cell References and the IFERROR Function
2. LOOKUP function with Joined "AND" Criteria as well as Mixed Cell References and the IFERROR Function

  • 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...