To Look Up Last Updated Price Of Relative Fruit

[raindrop]

Hi !

I want to look up last updated price of relative fruit ( Drop down List C2 in Sheet1 )from sheet2 database.
Herewith I am attaching a sample. Can anybody help me?

Thank You.

Raindrop

[HansV]

In E3, as an array formula, confirmed with Ctrl+Shift+Enter:

=SUM((Sheet2!A2:A10=MAX(IF(Sheet2!B2:B10=C2,Sheet2!A2:A10)))*Sheet2!C2:C10)

(rest to follow)

[HansV]

In F3, as an array formula (confirmed with Ctrl+Shift+Enter):

=DATEDIF(MAX(IF(Sheet2!B2:B10=C2,Sheet2!A2:A10)),I2,"Y")&" Years "&DATEDIF(MAX(IF(Sheet2!B2:B10=C2,Sheet2!A2:A10)),I2,"YM")&" Months "&DATEDIF(MAX(IF(Sheet2!B2:B10=C2,Sheet2!A2:A10)),I2,"MD")&" Days"

In G3, as an ordinary formula:

=COUNTIF(Sheet2!B2:B10,C2)

[raindrop]

Solved !..Thank You For Quick Reply Mr. Hans.

Regards
Raindrop