Arvi,

I am not sure that I completely get the layout, but could you use something
like

=MAX(IF(Movements!$A$2:$A$200=A2,Movements!$C$2:$C $200))

would get the latest date for that item, assuming that column C is the date
column

Then use, this to get the user with

=INDEX(Movements!$B$2:$B$200,MATCH(A2&latest_date, Movements!$A$2:$A$200&Move
ments!$C$2:$C$200,0))

or in one formula

=INDEX(Movements!$B$2:$B$200,MATCH(A2&MAX(IF(Movem ents!$A$2:$A$200=Sheet1!A2
,Movements!$C$2:$C$200)),Movements!$A$2:$A$200&Mov ements!$C$2:$C$200,0))

all array formulae

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Arvi Laanemets" wrote in message
...
Hi

I have a workbook where various items (computers, monitors, printers,
etc.)
are registered. Every item has a unique ID in format "Cyyyymmdd###" (Item
group+purchase date+3-character number. For every item group (a different
1st character) exists a separate sheet with different column collection.
In
every of those tables the leftmost column (A:A) is ItemID, and there
exists
a column User in every table.

On additional sheet (let it be Movements) all user changes are registered
RecNo, ItemGroup, ItemID, Date, User
<RecNo, p.e. A2=IF(C2="","",ROW()-1) is calculated automatically

On item sheets, I need the latest user (with latest date for this item)
from
Movements for every item to be displayed. The problem is, that the return
value is string - so SUMPRODUCT is not an option.


Thanks in advance for any help

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )