Find first non zero in row, find related value in column header, apply to other column

[syberjj]

Hello guys, my issue is quite complicated so I'll add this image to explain:
excel.png

The "Purchase Date" shows the name of the customer buying and the month the sale was closed.
the "Payment Date" show the date the customer's money came into the company.

But the comission % is not the same every month (acutally varies on how much the user sold, but I have a formula for that working fine).

In the "Purchase Date" column, I am able to see how much comission that salesman is going to get from that Sale (see formula in red) but I need to get the values from the day the money comes in.

I need a formula for the "Payment Date" section that will automatically get the right % values by getting the acording comission from the C2:N2 section.

Then, I need something to ignore the second formula by having something that will get all values in the column (in the formula example i18:i23) and apply the right comission from the B18:B23 area.

Then I can also ignore the second area of "Payment Date" (A18:N29 area) since it will already be included in the first one.

Does anyone know how to do that?

[kbkumar]

Hi - Dont think the image is going to be any help here, attaching the workbook will get you more faster / efficient responses.

Thanks.

[syberjj]

Spreadsheet download:
DOWNLOAD*NOW!

Second sheet is what I want to get