G
Guest
I have a cell, B1, and C1
B1's value is based on many conditions, and the result will be some other
cell's value, or 0.
i want a formula in C1 that says:
IF B1=0,0, else...
check's what cell B1 pulled its value from, skip 2 rows over, and copy the
value in the cell.
FOR EXAMPLE:
IF B1 ends up equalling B25's value ("Shoes")
C1 will end up equalling D25's value ("5")
B1's value is based on many conditions, and the result will be some other
cell's value, or 0.
i want a formula in C1 that says:
IF B1=0,0, else...
check's what cell B1 pulled its value from, skip 2 rows over, and copy the
value in the cell.
FOR EXAMPLE:
IF B1 ends up equalling B25's value ("Shoes")
C1 will end up equalling D25's value ("5")
100,MATCH(B1,B2:B100,0)))