Walking through the flames

There is always something heroic to get up from a difficult situation.

But you can have a thousand people around, and nobody will lend you a hand to help you out. Not at all. It is quite the other way around.

People will look on the other side and pretend they did not notice you lying on the floor and dying.

Remember one thing, though: when you get better (if you get better), those same people will be here to cheer with you and tell you how proud they are that you made it.

Moral of the story: do not wait for them to open a beer. You do not need anyone to have a drink.

The luxury of a glass of water

It was still dark outside. The window was slightly open. A new day was about to come. Every new day was only a pale copy from the yesterday’s template. What new? Nothing much, maybe a new pain. The lower back? The legs? The joints? It does not matter anymore.


A big mug of coffee will put all of this behind. Why am I having everything that I was dreaming of and still, the happiness seems to not be around? Maybe I should change my state of mind? Maybe… but, easy to say, harder to think. Working hard to see your bank account growing bigger and bigger and, in exchange, what do I get? White hair, dark circles. I live the dream of the poor. But its smile seems realer than the one on my face. Maybe this is the real price of things: time, health, and sleep.

When VLOOKUP looks to the left

Context

VLOOKUP is an Excel formula which looks up to the right to find a value.

For instance, if you want to know which customer is #282655, VLOOKUP can help you for this: the formula will return “Bastra”.

But, what if you want to find the customer number of Castero? In this case, VLOOKUP will not help you. Indeed, as we said before, the formula only looks to the right, but in our example, the Customer numbers are in the left column.

I will show you three methods to solve this problem:

  • Method A – Manual
  • Method B – Nested formula (which works on every Excel’s versions)
  • Method C – New era

Method A – Manual

In this method, we will simply copy data from column A and paste them in column C. The result column (customer number) will be displayed to the right of the column with the desired value (name):

We are now able to perform the VLOOKUP, but the table array will be column B and C:

This method is easy, but not productive at all. Indeed, suppose that you have tons of data. Or that the data in column A are from an external source.

Method B – Nested formula

The advantage of this method is that it is working properly on every Excel’s versions (including the old versions). You can then share your file with everybody, it does not matter which Excel’s versions they have.

This method is using two formulas: INDEX (Uses an index to choose a value from a reference or array) and MATCH (Looks up values in a reference or array).

We will have:

Method C – XLOOKUP

With Microsoft365, the firm from Redmond brought a gift for millions of Excel’s users: the VLOOKUP which looks to the left – XLOOKUP.

The structure of the formula is quite similar to the VLOOKUP, except that we must split the lookup array and the return array.

So, we will have:


You can download the file used as example here: