HLookup, Possibly...

Hi I have a problem with a table I have created.

I have a list of customers in Column B, & The Date they became a customer in COlumn A.

From Column D to BK, I have purchase dates.

In the corresponding cells I have a 1/0 dependant on whether a purchase was made on that date.

In BL I Have the number of Purchases made.

In BM I want the date that the first purchase was made....

E.g.
...Signup...Name.........27/7/06....28/7/06....29/7/06....Purchases..1st Time
1 27/7/06-John Smith-.....0.............1...........0..............1............28/7/06


Getting the first purchase date to be returned is my problem.

Ty.

Instead of entering 1 when a purchase is made, enter the date, then use MIN() function on the "purchase" row - if you get an error, no purchases made, trap with ISERROR().

if you are finding it for each row, then for row put in BM3
=if(BL3 = 0, "No Purchases till date", offset($C$1,0,match(1,D3:BK3,0)))

1st Post. Works. Thanks [=