Hi,
I'm looking to search a cell (Look Up Value), see if it contains certain text (from list) and return an adjacent cell's text (Adjacent Cell).
Not every text will JUST contain the text, so I need to find the text within other characters. In the example below, I'd like the formula to be in Column B and the first result would return "Fruit"
Example:
Look Up Value Result List Adjacent Cell TestApple Text Apple Fruit HippoHippoBig Hippo Hippo Animal 1234Hippo T-Rex Dinosaur
Something like this??
=IFERROR(LOOKUP(1000,SEARCH($D$2:$D$4,A2),$E$2:$E$4),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
It works, but it's finiky - I can only get it to work if the look up list array is exactly the same length as the look up list. So I can't just say look at column K:K... Is that right?
See if this helps.
Produce a table of Words and Categories then reference the table using:Formula:
Please Login or Register to view this content.
As your lists change the formula will still work.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I didn't receive a notification about your earlier reply. JeteMc's reply accounts for it. You extended the lookup range to include blank cells. You shouldn't have. A Table, or a dynamic named range will fix that.
=IFERROR(LOOKUP(1000,SEARCH(Search,D2),Response),"")
CTRL-F3 to view /edit the named ranges.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks