Make lookup values go WILD
Just like FIND function of Excel you can use wildcards in lookup value argument of VLOOKUP function as well. It makes lookup much more easy in certain situations especially if your lookup requirement is part of string.
Have a look at this situation where data extracted from database has somehow mingled the date, product and type.
If we want to fetch the price of apple then we can use the formulas fallows:
=VLOOKUP(“*apple*”,B5:C14,2,FALSE)
Though above approach works, but we have hard coded the “apple” in the formula. It will be easy if we can use reference to specific cell so that we change the product in the cell to fetch the relevant price instead of changing the formula every time. To do this we need to arrange things a little different way as following:
=VLOOKUP(“*”&G8&”*”,B5:C14,2,FALSE)
Thanxxx….. It is help lot of me..
Sorry but {=VLOOKUP(B20,B7:F15,{2,3,4,5},FALSE)} doesn’t work. I use (;) and result is always S M L XL
pants 18,00 18,00 18,00 18,00
Why ?
Salam Hassan Sir, I can not resist to inspire from your work. I am student cum employee. Excel is badly need for me. I want to learn excel with a full exposure. I am living in Rawalpindi, is there any possibility to teach me excel.?