PDA

View Full Version : Vlookup the price in latest date



apple
08-15-2009, 10:25 AM
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
08-15-2009, 11:06 AM
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
08-15-2009, 05:16 PM
Hi XLD,

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

apple
08-15-2009, 05:31 PM
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
08-16-2009, 01:38 AM
This is what I mean