The Vlookup function only looks up from the right side. To look up a value in any column and return the corresponding value on the left, you can simply use INDEX and MATCH in Excel.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Left Lookup in Excel
1. The MATCH function returns the position of a value within a specified range.
Explanation: 104 is found at position 4 in the range $G$4:$G$7.
2. Use this result and the INDEX function to return the 4th value in the range $G$4:$G$7.
3. Drag the formula in cell B2 down to cell B11.
Note: as we drag this formula down, the absolute references ($E$4:$E$7 and $G$4:$G$7) stay the same, while the relative references (A2) change to A3 , A4, A5,…
In addition, you can also view many other excel articles here.