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:

=LOOKUP(2,1/(NOT(ISBLANK(G30:G46))),G30:G46)
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;

=CELL("address",LOOKUP(2,1/(NOT(ISBLANK(G6:G22))),G6:G22))
Does anyone please have a suggestion on how I can achieve to pull the last cell address based on the above?

Thanks in advance!