Find last cell with data formula returning incorrect range

Hello again!

I have a formula:

Please Login or Register  to view this content.

data in A13 matches a sheet title. Then this formula is supposed to go to that sheet, and find the last cell, in column R, with data in it. This is important, because it returns a range that tells 5 other formulas where to find their data. (its all dynamic, but always in a fixed position relative to the last cell in column R)

This formula works perfectly, except when the data in the last cell in colum R is duplicated in column R.

For example, the data in R19 might be "8". In R14, the result of a calculation is also "8". The above formula then returns R14 as the last cell containing data, instead of R19.

Any thoughts?

That seems to have sorted it Tony! I greatly appreciate your help

And if you're a hockey fan, Go Pens Go!