Latest entry based on cell

[ExcelRoy]

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

 

[Eric W]

Try:

=IFERROR(LOOKUP(9.99999999999999E+307,1/((D12:D46<>"")*(A12:A46=C10)),D12:D46),"")

 

[ExcelRoy]

Hi Eric W,

That's great, thanks

Could there be another match included in the formula with column H the target range and cell reference =G10

Thanks again

 

[Eric W]

Try:

=IFERROR(LOOKUP(9.99999999999999E+307,1/((D12:D46<>"")*(A12:A46=C10)*(H12:H46=G10)),D12:D46),"")

 

[ExcelRoy]

Works perfect thanks Eric W

 

[Eric W]

You're welcome.