My Data Range is B4:L10 consisting of 5 columns (B,E,H,J & L)as shown
plus
B2, E2, H2, J2 & L2 is either of 1 or 0
Output required in N4:N10 as
‘grab’ the value from the corresponding row cell of B4:L10 which has 1 in B2:L2.
How to accomplish?
Thanks in advance
I am using Excel 2007
Sheet1...