Hey masterminds,
I've got a report I'm generating for several schools but am having some difficulty with a specific part of a formula. All of my formulas are based off an offset function. This offset function is moving a specific number of columns over based off a user's selection.
Here's the catch. I have a combobox that is pulling a list based off another offset function but I'm having trouble creating this list accurately.
Here's what I've got....
Unit Test = Manually entered list, "Data?" is checkng to see if Data exists for that test."Goal" is what I'd like to be able to pull for my combobox list.
Unit Test Data? GOAL
U1 1 U1
U2 1 U2
U3 1 U3
U4 1 M1
U5 0 M2
U6 0 BLANK
U7 0 BLANK
U8 0 BLANK
U9 0 BLANK
U10 0 BLANK
U11 0 BLANK
U12 0 BLANK
M1 1 BLANK
M2 1 BLANK
I've tried several helper columns and different variations of if formulas but to no avail. Please help!
Thanks y'all!
Bookmarks