Lets say I have the following table:
I would like to create 2 new columns with the help of a formula. one column for all the values=1 in B column and
one column for all the values=2 in B column. Those columns will return the matched values of column C by the order of column A but
when A=0 formula would do nothing and the next calculation would be written in that same cell.
In this example it should look like that:
I tried to use something like that (for new1):
I dragged the formula and then I tried filtering the "FALSE" but it is affecting the original matrix.
Please help me.
Best
A | B | C | |
1 | 1 | 1 | 0 |
2 | 0 | 1 | 1 |
3 | 3 | 1 | 6 |
4 | 0 | 2 | 2 |
5 | 5 | 2 | 3 |
I would like to create 2 new columns with the help of a formula. one column for all the values=1 in B column and
one column for all the values=2 in B column. Those columns will return the matched values of column C by the order of column A but
when A=0 formula would do nothing and the next calculation would be written in that same cell.
In this example it should look like that:
New1 | New2 |
0 | 3 |
6 |
I tried to use something like that (for new1):
Code:
=IF(AND(B1=1,A1<>0),VLOOKUP(B1,$B1:$C$5,2,FALSE))
Please help me.
Best
Last edited: