Hello friends,
I have a dropdown list (data validation) whos values may span several columns on another sheet. I need to reference cells in other columns on the same sheet, I have color coded these for the purpose of their appropriate associations. Please refer to my attached workbook. I can write this in VBA, but there must be a simpler way using references. I don't need the cell's value, only the A1:B2 references.
Also, How would I write an offset formulahelpmebook_Please.xlsx so that I could use the range produced as the 'COLS' section of the formula?
Bookmarks