I am trying to get a form control box to have a dynamic input based on a named range. I have named said range as "Selection" and want it to do a few things:
1. Offset from cell D1 to a column based on a match function
2. Have the Height of the Offset formula based on the column identified with the Match function.
I'm striking out on both fronts. Offset function I'm using:
Any help is appreciated
1. Offset from cell D1 to a column based on a match function
2. Have the Height of the Offset formula based on the column identified with the Match function.
I'm striking out on both fronts. Offset function I'm using:
Code:
=OFFSET(CodeList!$D$1,1,MATCH('LO - Initial Checklist '!Y5,CodeList!D1:N1,0),7,1)
Any help is appreciated