Hi All,

I am trying to get a formula that will lookup a date that is across row
c100:Z100

Column A3 to A50 contains names that are already being "matched" in
another sheet. The problem is that the names are in dropdown boxes and
there is data added into columns UNDER the date:

A C D E etc
Dates (starts in Column C)18/07/06 19/07/06 20/07/06
Bill 1 2 0
John 2 2 0


What I need is a formula that will return the DATE that Bill worked.
At the moment I have three columns in another sheet that I want the
data returned in

A B C

Bill 1
John 2

I want column C to be the dates they worked, but due to there being
dates ACROSS the fields I am having trouble.
The end result is that I can total the number of times bill did
something on the 18/07/06, and I have been unable to do this even using
a sumproduct formula.

Can someone help??


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=569328