I have an Excel 2002 worksheet which is used to requst merchandise called
"Orderform". Users enter a catalogue # of an item and someone will then order
that item. A history of all items ordered in stored in a separate worksheet
"Order History". The relevant columns of "Order History"are shown below:


A D H
Cat # Ordered By Date Ordered


Once a catalogue # is entered on in column H on "Orderform" I would like the
date the last time the item was ordered to appear in column I. If the item
was requested but not yet ordered, column I shows "Requested". This was
accomplished with the following code:

=IF(INDEX('U:\Excel\[Order
History.xls]Query3'!$H$2:$H$4000,MAX(ROW('U:\Excel\[Order
History.xls]Query3'!$A$2:$A$4000)*('U:\Excel\[Order
History.xls]Query3'!$A$2:$A$4000=H9)))="","Requested",(INDEX(' U:\Excel\[Order
History.xls]Query3'!$H$2:$H$4000,MAX(ROW('U:\Excel\[Order
History.xls]Query3'!$A$2:$A$4000)*('U:\Excel\[Order
History.xls]Query3'!$A$2:$A$4000=H9)))))

I would like column J of "Orderform" to return the corresponding name of who
ordered the item. Cat #'s, dates and requestor names can appear multiple
times in the "Order History" sheet. My thought was to find out what cell was
found in the formula above and then return the corresponding name from column
D but but can't figure out how to do this. Any suggestions?

TIA