looking for latest selling price..

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...

www.contextures.com/excelfiles.html

check out this site, it may give you some ideas

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

--
Don Guillett
SalesAid Software
[email protected]
"Lawrence" <[email protected]> wrote in message
news:[email protected]...
> 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...
>
>
>

Lawrence,

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

"Lawrence" wrote:

> 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...
>
>
>

Lawrence,
This link goes to the file I mentioned. No need to post your e-mail
address.

http://www.anywhereenterprises.com:8...OWOAApQZOAAIOQ


"Lawrence" wrote:

> 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...
>
>
>