Dear All,*
I am attaching herewith a file where i have a problem in vlookup formula. For a particular desc 18*50 - lookup picks up the amount of 180*250. pls refer the attached file and let me know where i am going wrong and how to correct the same?
Value of 18*50 is Rs.25 value of 18*250 is 60. against 18*50 vlookup functions returns Rs.60.... Pls help.
Regards,
Sreevidhya V
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 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!
CAclubindia
