Hi everyone,
I am looking for a slight change (I think) to the following formula
=IFERROR(LOOKUP(9.99999999999999E+307,1/(D12:D46<>""),D12:D46),"")
This looks up the latest/last entry in the range D12:D46
I am looking for a similar formula to look up the latest/last entry based on a cell data
ie
C10 has the cell data, so I need the formula to match the latest/last entry within D12:D46 if A12:A46 is matched with C10
Many thanks for any help
I am looking for a slight change (I think) to the following formula
=IFERROR(LOOKUP(9.99999999999999E+307,1/(D12:D46<>""),D12:D46),"")
This looks up the latest/last entry in the range D12:D46
I am looking for a similar formula to look up the latest/last entry based on a cell data
ie
C10 has the cell data, so I need the formula to match the latest/last entry within D12:D46 if A12:A46 is matched with C10
Many thanks for any help