How to get last date sold from multiple products

[Bram1212]

Hi all,

Hope you can help me with this one. I am looking for a formula which will give me the date a product was last sold. In our BI system we have quantity sold and the date but nothing like last sold on.

I have attached a file and am looking for a formula which will retrieve the info in G2 G3 G4.

Hopefully the example is sufficient. Otherwise let me know!

Thanks in advance.

 

[Bram1212]

Does this work?

http://tinypic.com/r/1znreow/9

 

[Fluff]

How about for product 1
=INDEX($A$2:$A$31,MATCH(9999,$B$2:$B$31,1))
just make sure that the value in red is larger than any number in the data.

 

[Bram1212]

I'll see if this works. I figured it out with a =LOOKUP(999;L6:NL6;$L$5:$NL$5) formula (different reach).

Thanks anyway!

 

[Fluff]

Glad you sorted it & thanks for the feedback