This article will show you how to look up two columns in Excel. See the example below. I want to look up the salary of James Clark, not James Smith, not James Anderson.
| Join the channel Telegram of the AnonyViet đ Link đ |
Look up two columns in Excel
1. To concatenate strings, use the & operator.
2. The MATCH function returns the position of a value within a specified range. Insert the MATCH function shown below.
3. Finish by pressing CTRL + SHIFT + ENTER.
Note: The formula bar indicates that this is an array formula by enclosing it in curly braces {}.
Explanation: The ranges (array constants) A2:A8 & B2:B8 are stored in Excel’s memory, not in a range. The array constant looks like this:
{âJamesSmithâ;âJamesAndersonâ;âJamesClarkâ;âJohnLewisâ;âJohnWalkerâ;âMarkReedâ;âRichardLopezâ}
This array constant is used as a parameter to the MATCH function, which returns 3 (JamesClark is found at position 3).
