Cobber2008
New Member
- Joined
- Nov 29, 2020
- Messages
- 28
- Office Version
- 365
Hi all,
I have this formula LOOKUP(2,1/(($BB3:$CAT3>0)*($BB3:$CAT3>=$AW3)),COLUMN(3:3)) which finds the column number of its > the value in AW3. I am looking to make the reference column number CAT dynamic and equal to a number in cell A1 which is value 216 (COLUMN 216) being HH.
So based on that what i am trying to get to is this LOOKUP(2,1/(($BB3:$HH3>0)*($BB3:$HH3>=$AW3)),COLUMN(3:3))
How can i do this?? I Hope this makes sense? Thanks.
I have this formula LOOKUP(2,1/(($BB3:$CAT3>0)*($BB3:$CAT3>=$AW3)),COLUMN(3:3)) which finds the column number of its > the value in AW3. I am looking to make the reference column number CAT dynamic and equal to a number in cell A1 which is value 216 (COLUMN 216) being HH.
So based on that what i am trying to get to is this LOOKUP(2,1/(($BB3:$HH3>0)*($BB3:$HH3>=$AW3)),COLUMN(3:3))
How can i do this?? I Hope this makes sense? Thanks.