Find the last occurance of a cell's contents (contains) and copy it's data to another cell

I have a example spreadsheet attached where I need a formula to look at the list and find the last occurrence of the text string "Nice Stuff", "Real stuff" and "Good stuff" but can contain numbers in the cell such as "12345 Nice Stuff"copy the data to the right of the cell and paste it into cell D8 for "Real Stuff" D9 for "Nice Stuff" and D10 for "Good Stuff" all in the other workbook tab named "MapTo". I know how to pick up the first occurrence but not the last occurrence.

I know where the first enter is on the worksheet (D7), but the list length will vary.

I used the array formula of

Please Login or Register  to view this content.

found in cell D8 of the MapTo tab that mikerickson a of Davis CA a Forum Guru, but the requirements have changed from an exact match to "Contains"


Help would be greatly appreciated

cannot see attachment

not sure why this needed an xlsm file but anyway...

my problem is "Nice 12345 Stuff"
cause then really you are looking for nice and stuff separately...which would mean having to break down every cell by space to find a combination of the two words?
probably doable but a bit beyond me if you really want that type of solution

for the rest of them

CSE formula

Formula:

Please Login or Register  to view this content.

humdingaling,

Thanks for the thoughts and formula. I will think over the problem and see if there may be a change in requirements that could make the formula simpler

Get back to you tomorrow!

it depends highly on the format on what you are trying to search

For your specific example..this should work

Formula:

Please Login or Register  to view this content.

Another option:

Please Login or Register  to view this content.