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