Here is more to learn about VLOOKUP!
Check out following tutorials where VLOOKUP shined even brighter:
- Excel Dynamic Data Validation Lists – Explained
- Stock Ageing Analysis Reports using Excel – How To
- FREE Excel Invoice Template V1.0 with Customer and Product list – Unlocked + Download ready!
- How to do 2 Way Lookup in Excel – One value to lookup with two criteria using Intersect Operator
- Read all Excel VLOOKUP articles here!
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.?