Return Cell of nth Match

Hi all,

I hope you don't mind but I am going to ask for 2 results in this thread for similar formulas.


1. This formula I found works great for returning the nth value in a single column (in this example second match):

=INDEX('Table 1'!$A$1:$A$3000,SMALL(IF('Table 1'!$A$1:$A$3000="Done",ROW('Table 1'!$A$1:$A$3000)),2))

However, can some please edit the formula so that the searched cells contain "Done", not the whole cell reference (eg. cell A15=xxxDoneYYYzzz)



2. Similar, this formula works well and returns the desired cell reference. Can you tell me how to edit the formula to find the nth match in the column.

=CELL("address",INDEX('Table 1'!$A$1:$A$3000,MATCH("*"&"Done"&"*",'Table 1'!$A$1:$A$3000,0)))


Thank you so much

Danny