Excel Forum

Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH

Download file: http://people.highline.edu/mgirvin/
Two Lookup Values and Two Lookup Columns to Return Items to A Table Format
See how to lookup two items (two criteria) from two different columns and return a single item using a single cell formula (Does not require an extra column of concatenated values) and does not require Ctrl + Shift + Enter. See the functions INDEX, MATCH. See how INDEX function can take an array that requires Ctrl + Shift + Enter and if you leave the row argument blank, INDEX can deliver the array without Crtl + Shift + Enter.

Also see:

Excel Magic Trick 757.5: Lookup With Two Criteria Or Sum With Two Criteria?

Got a Question? Ask it Here in the Forum.