[Pindi-Islamabad:94697] Excel Tip: Use Vlookup to extract values

Situation: 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?

Data:

Solution

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

Examples:

Sample File

Download Example File – Using Wild cards with VLOOKUP formula

Special Thanks to

Michael Pennington, Lukas for the tip. (Click on the name to see their tip)

Labels: Analysis , analytical , career , effective , skills

--
--
{{{{ Rawalpindi-Islamabad Friends}}}}
 
************************************************************************************
All members are expected to follow these Simple Rules
Abuse of any kind (to the Group, or it's Members) shall not be tolerated
SPAM, Advertisement, and Adult messages are NOT allowed
This is not a Love, Dating Forum so sending PM or Chat Inv will be considered as illegal Act. will be BANED Instantly.
************************************************************************************
You received this message because you are subscribed to the Google
Groups "Pindi-Islamabad Friends" group.
To post to this group, send email to Pindi-Islamabad@googlegroups.com
To unsubscribe from this group, send email to
Pindi-Islamabad+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Pindi-Islamabad?hl=en
 
---
You received this message because you are subscribed to the Google Groups "Pindi-Islamabad Friends" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Pindi-Islamabad+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.