Making VLOOKUP formulas go wild [VLOOKUP Week]
Often we need our lookup formulas to go wild. Not in the sense of go-wild-and-chomp-a-few-kilo-bytes-of-data sense. But wild like wild cards.
For eg. In the below data, we may not remember the full name of sales person, but we know that her name starts with jac. Now how do you get the sales amount for that person?
Simple. Use wild cards. Like this:
=VLOOKUP("jac*",$B$5:$E$17,3,FALSE) to fetch the value from 3rd column for the person whose name starts with jac
Special Thanks to
- Excel SUMIF and COUNTIF Formulas – What are they, how to use & examples
- Search Workbooks using Conditional Formatting & Wildcards
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« What is VLOOKUP Formula & How to use it?||Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week] »|