Excel Magic Trick 1100

Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication

DESCRIPTION

See Two Methods that can return a “Yes” when a Two Way Lookup based on a Column Header and Row Header must lookup items from a second table that presents Dimension (row / column size) Problems
(01:59) 1. Method 1: INDEX to lookup a row based on a column header that can then be matched against a row header. See the functions: INDEX, MATCH, ISNUMBER and IF. Learn about array syntax. Learn that although the evaluated INDEX function looks like it returns an array, it actually returns a range that the MATCH function can understand.
(08:09) 2. Method 2: Array Comparative Operation and Array Multiplication. See the functions SUMPRODUCT and IF. Learn about array syntax.

WORKBOOKS

Download “Excel Magic Trick 1082 - 1100” Excel-Magic-Trick-1082-1100.zip – Downloaded 97 times – 2 MB




Be the first to comment

Leave a Reply