Dueling Excel 150

Lookup First Item when Other Column Contains Greater Than 100

DESCRIPTION

See Mr Excel and excelisfun lookup the first value in column A when the first value in B is greater than 100:
(00:13) Method 1: IF function and array operation inside MIN function inside INDEX function. Requires Ctrl + Shift + Enter.
(03:03) Method 2: Array operation inside MATCH function inside INDEX function. Requires Ctrl + Shift + Enter.
(05:02) Method 3: Array operation inside of INDEX function inside MATCH function inside INDEX function. Does NOT require Ctrl + Shift + Enter, just Enter.

WORKBOOKS

Download “Dueling-Excel-141-150.zip” Dueling-Excel-141-150.zip – Downloaded 104 times – 185 KB




Be the first to comment

Leave a Reply