Hello,
I am trying to create a spreadsheet that will lookup miles traveled in spreadsheet A. And if that name of place matches the same name in Spreadsheet B, it will post the miles traveled field from Spreadsheet A into the corresponding named place in Spreadsheet B.
The names are not exact, so the field must state "if contains text" rather than "exact match"
Thanks
Here is formula
=INDEX(A!$B$2:$B$5,MATCH(1,IF(ISERROR(SEARCH(A2,A!$A$2:$A$6)),"",1),0)) CSE
For clarity look to the file. Simulated there
Appreciate the help? CLICK *
Thank you, I will try this.
Book1 (Recovered).xlsxBook1 (Recovered).xlsxHello, May I send you my file so you can show me more exactly how to place that Lookup formula?
I tried it but am new and not understanding.
I have attached my file:
I am wanting to lookup any matching names in column C of this worksheet 1, and find the miles traveled from the same names in worksheet 2, column A.
Thanks
Last edited by kirtan; 04-09-2013 at 03:12 PM.
Sure, upload it here from Advanced button.Originally Posted by kirtan
Book1 (Recovered).xlsxBook1 (Recovered).xlsx
Here is my file thanks for your help!!!!
Hello? Did you receive the file?
I looked to the file but none of the names in Sheet1 column c is in the sheet2 columns. There few common words. But one of the names must be placed fully in another cells.
Ok, I see. I will manually change the names in the field to more closely match. Could you send me the formula that you would use in my file? Can it look for a word that "starts with" or "contains" matching names in sheet 2 column B, or does it need to be "exact match"?
My Formula look for word that contains. Formula is above and you can get it from the my uploaded file too.
Writing again =INDEX(A!$B$2:$B$5,MATCH(1,IF(ISERROR(SEARCH(A2,A!$A$2:$A$6)),"",1),0)) CSE
Many thanks and blessings to you friend!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks