Hi,
I am using the below formula in a spreadsheet to do a calculation where a cell reference equals 1. What I am hoping to do is use a function to work out what that cell reference is...
=IF(ISERROR((IF(D13=1,$C13/D$3,""))*D$2),"",(IF(D13=1,$C13/D$3,""))*D$2)
So, at the moment I use D13=1, and then drag it down so the cells below say D14=1, D15=1, D16=1 etc....
Now, in my spreadsheet I have 2 lists...one list has projects in column A (A13:A54) and months across the top (D12:O12). I then put a "1" in each month that each project is running.
The 2nd list has the same (A58 onwards), but under each month I use the formula I put above.
What I want to do is replace the "Dxx" in the formula to look up the project name in A58 onwards, find that name in the first list and put the applicable cell reference in place of "Dxx"....
Does that make sense, and is it possible?
I am using the below formula in a spreadsheet to do a calculation where a cell reference equals 1. What I am hoping to do is use a function to work out what that cell reference is...
=IF(ISERROR((IF(D13=1,$C13/D$3,""))*D$2),"",(IF(D13=1,$C13/D$3,""))*D$2)
So, at the moment I use D13=1, and then drag it down so the cells below say D14=1, D15=1, D16=1 etc....
Now, in my spreadsheet I have 2 lists...one list has projects in column A (A13:A54) and months across the top (D12:O12). I then put a "1" in each month that each project is running.
The 2nd list has the same (A58 onwards), but under each month I use the formula I put above.
What I want to do is replace the "Dxx" in the formula to look up the project name in A58 onwards, find that name in the first list and put the applicable cell reference in place of "Dxx"....
Does that make sense, and is it possible?
