Download Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates video at savevid.com

Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates

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: http://www.youtube.com/watch?v=EQcx6YUZGGg
Rate: Please rate this video Views: 46 Downloads: 29
Description: See how to take a value in a table and then return the row or column value when there are no duplicate values. See how to do a reverse two-way lookup when there are no duplicate values. Array formula that uses the functions: INDEX, MAX, IF, COLUMN functions.
Learn about how an Array formula can deliver the first number in the array or all the values in the Array.
This video is in response to the video: Excel Magic Trick #118: Reverse 2-Way Lookup Part 2
Tags: take, mike, table, college, community, value, formula, return, excel, functions, column, girvin, highline
Category: Flag video Science & Technology