looking for latest selling price..

L

Lawrence

i have a file like this...

Items Date price
AAA 15.5.2005 1.5
BBB 16.5.2005 1.6
CCC 17.5.2005 1.4
DDD 18.5.2005 2.3
AAA 19.5.2005 1.4
CCC 20.5.2005 1.3
VVV 21.5.2005 1.2

in another worksheet i have a worksheet like this...but without the price
and date

Items Date Price
AAA ??? ???
BBB ??? ???
CCC ??? ???
DDD ??? ???
VVV ??? ???

can i know how to find the latest selling price in second worksheet???

if possible for both price and date...

thanks...
 
D

Don Guillett

try using =MATCH("ddd",a:a) to find the row and then use INDEX for the
column or a macro to do it all.
 
R

Roland

Lawrence,

Post your e-mail address and I send you a little spreadsheet that takes
care of this.
 
Top