Hi Aplesh / Kgrabbs, Thank you very much.
Regards Hari Kumar -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of kgrabbs Sent: Friday, April 03, 2009 6:32 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Hi I would require help on vlookup with search option 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
