Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cells

See how to lookup two values at once and return then both to: 1. One Cell using 2 VLOOKUP functions and concatenation (Ampersand &) 2. Two Cells using 1 VLOOKUP and the COLUMNS function Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm