|
|
Featured Tutorial
Featured Macro
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
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