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

Try this:

=IF(B1=0,0,INDEX(D2:D100,MATCH(B1,B2:B100,0)))

Adjust the ranges to suit.

Biff

"Mo2" wrote in message
...
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")