Excel Forum
Similar Content
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: Logical comparison operators allow you to compare values in Excel to see if they are equal...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Add Values to a ListBox
Tutorial: How to fill a Listbox with values in a UserForm. By default, a Listbox in a form will be e...



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.