Perform IF function for a range of input cells, then use corersponding cells if correct.

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.

You can probably do it using an INDEX and MATCH combination, but I don't understand your nomenclature so you'll have to explain things in a bit more detail.

Pete

Hi r2fro,

I think you can use the VLOOKUP formula.

If your X's and Y's are in the range $X$1:$Y$50, then use this formula in C1

=IF(ISNA(VLOOKUP(A1,$X$1:$Y$50,2,0)),"",B1-VLOOKUP(A1,$X$1:$Y$50,2,0))

Let me know if this doesn't work...

Later,
Dennis

re-post: Sorry Pete, I seem to be always posting slower than you...

Originally Posted by djapigo

Sorry Pete, I seem to be always posting slower than you...

I was beginning to think you were stalking me, Dennis !! <bg>