Find last row in column with matching text and return contents

[Macfool]

I have a log sheet where data is transferred into and part of the cell value contains $C$3 for example, the following formula I found returns the first matching cell, how can I modify the formula to return the last matching cell in column A.
This is the formula that I have

Please Login or Register  to view this content.

Thanks for any assistance

[Richard Buttrey]

One way would be a helper column B
B2 copied down: =IFERROR(FIND($M$1,A2),"")

Then your formula would be
=INDEX(A2:A20,MATCH(9^99,B2:B20),1)

[Bo_Ry]

Maybe try

=lookup(1,-search(C3,A2:A20),A2:A20)

[Richard Buttrey]

...is the cell in question a formula which contains the $C$3 treference, e.g. =E3+$C$3
or is the $C$3 some literal text.

Uploading a workbook would help

[Macfool]

Thanks Richard & Bo-Ry both your formulas worked, I will mark this as solved.