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")