Excel doubt on vlookup

Hi Sreevidhya,

I dont know why it is coming like this as I am not a technical guy.

But if you try as per the below working in the attached sheet you will get the proper result.

Maybe some technical person might explain you clearly why it is happening like this.

I have also tried to find out what is problem

but excel is not responding to any adjustment, only solution I got is replace your ' * ' sign by ' X ' (i.e. by sign 18*50 to 18 X 50) for all your measurements

Hi,

Arrange the Vlookup table in Ascending order , then you will get the correct result. If you have large set of data and  find difficult to arrange the vlookup table in Ascending order please do let me know so that I could suggest other alternate.

The asterisk as a wildcard (*)

The first wildcard we want to examine is the asterisk symbol. This is the most general wildcard of the group.

The asterisk wildcard can take on the value of any number of characters.

For instance, if we substitute the asterisk like ‘Sh*’, it could represent strings like ‘Sheet’, ‘Show’, ‘She’, ‘Shake’, ‘Shoes’, ‘Shirts’, and so on.

It can be placed at the beginning of a string like “*-01”. This would recognize all values that end with ‘-01’ regardless of the number of characters preceding it.

The usefulness of the asterisk as a wildcard should start to become a bit more obvious to you by now, right  ?

Whenever using *, Follow this rule:

Just replace the * with ~*. You will get the correct answer.

Caution: Also use substitute function instead of find and replace box.

Why? This because whenever there is the asterisk, it tries to find the lookup value that starts with 18 and ends with 50. It does not care about the in-between letter/numbers. As 180*250 is top in a search, Lookup gives the resulting value of 180*250.

Hope this helps!