Hi there,


I want to perform the simple calculation below but with a few customisations... I hope someone can help

If( A1=X'x' , (B1-Y'x'), "" )

1) I wish to perform the calculation for a range of cells (X)
2) when the X'x' value that matches A1 is found, I want to use other cells in the corresponding 'x' row for another part of the calculation.


Thakns in advance for any help.

Cheers.