Your question is not entirely clear as to what you want, but let me take a
guess. Put this formula in Row 2 (I've assumed Row 1 is a header row) of an
unused column and copy it down...

=INDEX(A2:G2,1,1+SUMPRODUCT((A2:G2="K5")*COLUMN(A2 :G2)))

--
Rick (MVP - Excel)


"Brad Autry" wrote in message
...
Greetings,

I need a date for specific product purchase. The data provided me was
arranged as follows:

Customer IDs in column A.
Subsequent columns are alternating between product ID and Date.

I only require the date of purchase for product K5, however each customer
may have that product listed in a different column from others.

Small example to illustrate; I apologize as the formatting will not appear
correct:

Customer ID Product Date Product Date Product Date
1234 A1 1/2/10 B4 12/1/09 K5
10/12/06
3324 K5 9/22/08 A1 3/14/07 B4
2/28/04
9845 B4 1/13/09 K5 6/29/03 A1
12/12/23


Thanks in advance for any suggestions!

Regards,
Brad