I'm searching for a function that stipulates the following:
If the value in A2=1, then enter the value in B2 in the cell of C2.
If the value of A2=2, then enter the value in B2 in the cell of C2.
Etc.
So if I'm clicked in C2:
IF(A2=1, "the value I want in B2","0")
Any ideas? Thanks.
Bookmarks