Excel Forum

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

Got a Question? Ask it Here in the Forum.