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 > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
address(1).xls
Description: MS-Excel spreadsheet
