Excel Forum
Similar Content
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Transpose a Column into Multiple Rows in Excel
Tutorial: Convert a column of data into multiple rows of data at a given interval. For instance, e...

Excel Magic Trick #118: Reverse 2-Way Lookup Part 2

Watch Part 1 first. This Part 2 gets very complicated, but it is quite cool: See the functions, IF, INDEX, MATCH, SMALL, TEXT, ROW, ROWS, COLUMN and COLUMNS all in one array formula.

See how to do a Reverse 2-Way Lookup with a complex Array formula.

See how to populate a list of names for patients with schedule book entries using this complex Array formula.

Got a Question? Ask it Here in the Forum.