umm..hard to explain..

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

 

[T. Valko]

Try this:

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

Adjust the ranges to suit.

Biff