Lookup value, return column header

My title would have been a paragraph if I truly described what I needed, so sorry if my issue isn't totally defined by the title. Here is my issue:

I have a worksheet (sheet2) with rows that contain ID #'s in column A and one of the following values {0,33,50,100} in each cell from column G to AG. I want to focus on the cells with "0"s in them. Here is what I need:

In sheet1, A1, I want to type a Student ID. I then want to enter a formula in B1 that looksup the ID in Sheet2 and returns the column header of the 1st "0" it finds

Next, in Sheet1, B2, I want to enter a formula that will lookup the A1's ID in sheet2 and return the column header of the 2nd "0" it finds.

I want to end up with values in B1 to B10 in sheet1 that are the column headers of the first 10 zeros in each row in sheet2 based on the ID that I type in A1 in Sheet1.

A lot to ask, I know, but you all are brilliant so I hope you can find a solution.

Thanks,

John

Pl see the attached file.

Perhaps I made a mistake creating arbitrary cell references. In Sheet 1, my student ID is in O2, not A1. I need the Column Headers to be placed in the following cells: O13, O34, O55, O76, O97, O118, O139, O160, O181, O202. I tried Martin's and Kvsrinivasamurthy's but neither worked.

Any thoughts?

I hope I attached it correctly. I made notes in the rows of Sheet 1

PL see the attached file.
If it is OK mark thread solved.
Thanks.

Some of the entries are incorrect. Here are headers that are zeros for 196705:

MA.9-10.2.2.PO 2
MA.9-10.2.3.PO 2
MA.9-10.2.3.PO 3
MA.9-10.3.2.PO 2
MA.9-10.3.3.PO 11
MA.9-10.3.3.PO 13
MA.9-10.3.3.PO 14
MA.9-10.3.3.PO 3
MA.9-10.3.3.PO 5
MA.9-10.3.3.PO 6
MA.9-10.3.4.PO 1
MA.9-10.4.2.PO 4
MA.9-10.4.3.PO 5
MA.9-10.4.3.PO 8

Some have been skipped over, and some that ARE on Sheet 1 shouldn't be.