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...
Excel VBA MsgBox - Message Box Macro
Tutorial: Create a pop-up message box in Excel using VBA Macros. This allows you to show a message t...

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.