lookup date less than or equal to

[Tina]

H
I have some orders data with ship date and creation date each change to oder is recorded with ship date and creation date of change. when part of order is shipped I need to lookup this ship date on creation field and find where equal or less than and select ship date required
example if order 1 part shipped on 01/04/04 need to return answer 05/04/0
order no change code ship date req creation dat
1 001 01/04/04 10/03/0
1 002 05/04/04 15/03/0
1 002 09/04/04 06/04/0
Hope this makes some sens
Thanks Tina

 

[Frank Kabel]

Hi Tina
not quite sure but try
=INDEX(C1:C100,MATCH(DATE(2004,4,5),D1100,1))

--
Regards
Frank Kabel
Frankfurt, Germany

Hi
I have some orders data with ship date and creation date each change

to oder is recorded with ship date and creation date of change. when
part of order is shipped I need to lookup this ship date on creation
field and find where equal or less than and select ship date required.

 

[Tina]

Fran
Thank you very much it works well
I had got a little lost with index and matc
My head feels better no
thanks agai
Tina