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



Online Courses for microsoft excel :

Course updated 2010-09-03 18:17:16

Instructor : ExcelIsFun

Course Duration : 6:35

Rating : 4.94 / 5

Step by step & Descreption :
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: