I’m sure you know VLookUp but have you met its more versatile cousin XLookUp ? If you try it, you’ll never use VLookUp again.
Why? Well, let me enlighten you:
- Left-Side Retrieval: You can retrieve a value which is on the left of the looked up value ;
- No Column Counting Needed: No need to count the number of columns ;
- Auto-Adjusting Formula: If you add or delete a column, XLookUp will gracefully adapt.
Here is how to use it :
=XLOOKUP(E3;B:B;C:C)If you want the value to be 0 in case the looked-up value is not found, just add 0 at the end of the formula:
=XLOOKUP(E3;B:B;C:C;0)But wait, there’s more. You can even reverse the lookup, scanning from bottom to top:
=XLOOKUP(E3;B:B;C:C;0;0;-1)
As I said, you’ll never use VLookUp again!