Vlookup the price in latest date

[apple]

Hello,

I want to vlookup sheet A and sheet B with column Manufacture Number.
The vlookup must based latest date with latest price. Attached is the sheet 1 and sheet 2 is the result vlookup.

I will use in VBA for this vlookup. Can anybody show me the way to solve this.

Thanks

From,
Apple

[Bob Phillips]

Use these array formulae

C2: =INDEX(Date!C:C,MATCH(1,(Date!$A$2:$A$20=Result!A2)*(Date!$B$2:$B$20=B2)*(D ate!$D$2:$D$20=D2),0)+1)

D2: =MAX(IF((Date!A2:A20=Result!A2)*(Date!B2:B20=B2),Date!D2:D20))

Watch out for spaces being inserted in Date!

[apple]

Hi XLD,

Can you explain line by line as i do not understand. Thanks

[apple]

Hi,

Sheet1 is my data
Sheet name Fill in and compare: I will fill in manufacture number and compare. Press extract button
Sheet name result: The output i need.

Can anybody show me

[Bob Phillips]

This is what I mean