[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Type[/TD]
[TD]Black[/TD]
[TD]White[/TD]
[TD]Grey[/TD]
[TD]ANSWER[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]single[/TD]
[TD]1 x 5m[/TD]
[TD][/TD]
[TD][/TD]
[TD]Black[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]multi[/TD]
[TD]1 x 5ml[/TD]
[TD]1 x 5ml[/TD]
[TD]1 x 5 ml[/TD]
[TD]multi[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]single[/TD]
[TD][/TD]
[TD][/TD]
[TD]1 x ml[/TD]
[TD]Grey[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]twin[/TD]
[TD][/TD]
[TD]2 x 5ml[/TD]
[TD][/TD]
[TD]White[/TD]
[/TR]
</tbody>[/TABLE]
I need to find the answer to E2:E5 by
If type = multi then Answer =multi
else ANSWER is the value of B2:D2 where the Active cell row is not blank
Hope this makes sense.
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Type[/TD]
[TD]Black[/TD]
[TD]White[/TD]
[TD]Grey[/TD]
[TD]ANSWER[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]single[/TD]
[TD]1 x 5m[/TD]
[TD][/TD]
[TD][/TD]
[TD]Black[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]multi[/TD]
[TD]1 x 5ml[/TD]
[TD]1 x 5ml[/TD]
[TD]1 x 5 ml[/TD]
[TD]multi[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]single[/TD]
[TD][/TD]
[TD][/TD]
[TD]1 x ml[/TD]
[TD]Grey[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]twin[/TD]
[TD][/TD]
[TD]2 x 5ml[/TD]
[TD][/TD]
[TD]White[/TD]
[/TR]
</tbody>[/TABLE]
I need to find the answer to E2:E5 by
If type = multi then Answer =multi
else ANSWER is the value of B2:D2 where the Active cell row is not blank
Hope this makes sense.