=Index(C1:C6,MATCH("112311/11/04",A1:A6&TEXT(B1:B6,"dd/mm/yy"),0),1)

would work. Entered with Ctrl+Shift+Enter rather than just enter. I
assume you haven't entered it with Ctrl+shift+enter

this assumes that column A contains numbers and column B actually holds
Excel date values.

Frank's would be:

=INDEX(C1:C100,MATCH(1,(A1:A100=1123)*(B1:B100=DAT E(2004,11,11)),0))
also entered with Ctrl+shift+Enter

Both worked for me in a test sheet.
--
Regards,
Tom Ogilvy


"amar9876 " wrote in message
...
still cant get them to work

say ive got


A B c

1 1123 10/11/04 11


2 1123 11/11/04 12


3 1123 12/11/04 13

in box d1 say i want to search the list for item 1123 with date
11/11/04 and copy whats in colum c of this corresponding row.

thanks guys


---
Message posted from http://www.ExcelForum.com/