Find cell location of very last non blank cell in range

[lookingforhelp1]

Hi there,

I'm really struggling to get this working myself so I'm hoping someone can help me out please.

The spreadsheet I use has a range of numbers in a list (in no particular order).

I can pull the actual last value using:

Please Login or Register  to view this content.

However, ideally, I need to get the actual cell address of this value so I can use an Indirect function on another part of my spreadsheet.

I've tried the following but this doesn't work;

Please Login or Register  to view this content.

Does anyone please have a suggestion on how I can achieve to pull the last cell address based on the above?

Thanks in advance!

[zeshan.munawar]

Try this...

=MATCH(LOOKUP(2, 1/(NOT(ISBLANK($C$8:$C$20))), $C$8:$C$20),C:C, 0)

Thanks

[FlameRetired]

Try this

Please Login or Register  to view this content.

[Glenn Kennedy]

Can you not use your original formula as a term (INSTEAD of a cell address) in your other formula? Depending on what you're doing, you may not need INDIRECT at all.

[lookingforhelp1]

Try this

Please Login or Register  to view this content.

Many thanks this one did the trick.

Thanks everyone for their input!

[FlameRetired]

You're welcome. Thanks for the feedback and rep.