Embedding Lookup - 1135 - Learn Excel from MrExcel Podcast

Added by MrExcel Subscribe 21
Published 3 Nov 2009
139
••• More
Report video
0 0
You have already voted for this video.
Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested I...
Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested IF limit, so I decided to use the range version of VLOOKUP. But...as a twist, I embed the table right in the formula. Episode 1135 shows you how.

This is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Categories: How To
Show moreShow less
Report this video as: