In order to use Savevid on Chrome please follow these 3 simple steps:
Still having problems? Try downloading Savevid again (NOTE: Link will be to a direct download)
Download Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? video on savevid.com
Download Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? streaming video in flv, mp4, avi formats direct easily on Savevid.com.
Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?
- Provider: YouTube Link:
- Rate: Please rate this video Views: 12 Downloads: 19
See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) and excelisfun uses a formula with INDEX, IF, SMALL, MATCH, TEXT, CHAR and COLUMNS functions.
INDEX and MATCH magic
- Category: Flag video