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
Bookmarks