Download Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH video
Download Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH video on savevid.com
Download Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH streaming video in flv, mp4, avi formats direct easily on Savevid.com.
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formu...
- To download Youtube videos you should click "Run" when java window opens. Enable "Always trust content from the publisher" to download seamlessly in the future.
- Download video
-
Provider:
Link:
- Rate: Please rate this video Views: 13 Downloads: 14
-
Description:
Download file:
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? - Tags:
- Category: Flag video









