I have range of data Range1 E2:O2 (11 cells) values in which are either of 444 or <>444 with a caveat that at a time, at the most, only one 1 cell of E2:O2 may contain 444; columns are contiguous.
B2=has formula which generated value either of 1 to 11 or zero or null
Output cell (formula requested for this) T2 as described below
If 444 is generated in the ‘same number of position’ of E2:O2 which is equal to B2, T2=R2 else T2=null.
T2=null if B2=0 or null
T2=null if there is no 444 found in any of the cells E2:O2.
How to accomplish please?
Bookmarks