Jeez, what a terribly undescriptive subject! sorry
Lookup range has values "<City>, <State>":
- Chicago, IL
- NYC, NY
- LA, CA
- Denver, CO
Lookup value is "<City>":
- Chicago
- Denver
- LA
- NYC
Can anyone suggest a formula that will return the value from the first list given items from the second list as input?
I was thinking of some sort of array forumla using FIND, but I haven't had any luck.
(Actual data is several thousand records in length for both lookup values and reference)
Last edited by alanconde; 10-11-2011 at 01:41 PM. Reason: solved
Assuming list is in column A, try:
=INDEX(A:A,MATCH(C1&"*",A:A,0))
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Brilliant (and fast); thank you!!!
You're welcome.
If this has answered your question, please mark your thread as solved. See my signature for details or the FAQ.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks