Good morning, I have a spreadsheet with lots of columns of dates, where I compare three columns to give me a Y, N or 2 answer.
=IF($D9=””,””,IF(AND($D9=$JV$2,NOT(ISBLANK(BK9)),NOT(ISBLANK(JJ9)),NOT(ISBLANK($AT9)),BK9<=JJ9,BK9<=$AT9),”N”,IF(AND($D9=$JV$2,NOT(ISBLANK(BK9)),NOT(ISBLANK(JJ9)),NOT(ISBLANK($AT9)),$AT9<=JJ9),2,IF(AND($D9=$JV$2,NOT(ISBLANK(BK9)),NOT(ISBLANK(JJ9)),NOT(ISBLANK($AT9)),BK9>JJ9,$AT9>JJ9),”Y”,””))))
The spreadsheet has a few hundred rows.
Is it possible to have the formula change the column reference for columns JJ and BK change depending what I select from drop down boxes, one for Column JJ and one for column BK?
Thanks you.
I have tried INDIRECT without any success.
1