I had not known you can add wild cards to vlookups. That is really
cool. One note of caution is that I got false positives when entering
the name George. The method stated above will display results upon
the first match, which in this case was "George, Bush" and not
"George" as in Jefferson. This was also true when entering "B", "J",
"H", or "K" which are all partial matches. So I built upon the
vlookup with wild cards and added the ISERROR function combined with
an IF statement. This function will use the exact match first before
using the wild card vlookup.
[Cell D5]
=IF(ISERROR(VLOOKUP(D2,data!$B:$D,3,0)),VLOOKUP("*"&D2&"*",data!$B:$D,
3,0),VLOOKUP(D2,data!$B:$D,3,0))
Cheers,
kgrabbs
On Apr 3, 9:33 am, Alpesh Juvarewala <ajuvarew...@gmail.com> wrote:
> Hi,
> Pls find the attached solution. The trick is to use wild card
> character. The limitation is that the text should not be repeated in
> any other cell or else the result may not be as per expectation.
>
> 2009/4/3 hari <prekkeh...@gmail.com>:
>
>
>
> > Hi All,
>
> > I would require the output “city name from sheet “Data” on input of First
> > Name in the sheet”require information”
>
> > I tried vlookup which matches for exact search. Can anyone please suggest
> > how to use vlookup after using search or finding a string?
>
> > Enclosed please find the file.
>
> > Regards
>
> > Hari Kumar
>
>
>
> address(1).xls
> 29KViewDownload- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
