Hi,
I am trying to pull content of cells with text that ends in specific characters out of several columns of data. What I want is colum G to display the one name in the row that has TREE at the end. I am trying something with RIGHT(XX, 4) but can't get a lookup to work for it. can you help, here is an example file...
Book1.xlsx
Last edited by caliskier; 04-05-2012 at 04:57 PM.
Try This out and let me know how it works for you
=INDEX(B3:E3,MATCH("*TREE",B3:E3,0))
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Also,
=HLOOKUP("*TREE",B3:E3,1,0)
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thanks, I used the HLOOKUP one, but I am sure the index would have worked as well. I did not know you could use lookups that way.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks