I need help in excel formula lookup

Copper Contributor

I need a lookup formula that get me the last cell that contain a specific part of text


2 Replies



Maybe with this formula in cell C3. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.


Maybe with this formula in cell D3.

last cell S or P.JPG 

@AGB200 As a variant AND only if you have Excel MS365 or 2021.



A2:A12 is a named range called myList.

Formula in D1: