Find cell location of very last non blank cell in range

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!

Try this...

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

Thanks

Originally Posted by FlameRetired

Try this

Formula:

=ADDRESS(LOOKUP(2,1/(NOT(ISBLANK(G6:G22))),ROW(G6:G22)),COLUMN(G6:G22))

Many thanks this one did the trick.

Thanks everyone for their input!