IF Statement Based on 4 other options.

[budvegas]

Hi Everyone

I have been going crazy trying to work this one out.

I have attached an example.

It is quiet difficult to explain but I will give it a go

If cell F3 equals J3, J4, J5 or J6 then in cell H3, sum F3-K3 (or K4/K5/K6 depending on the value of F3)

Any assistance would be hugely appreciated.

Thanks in advance

[Ace_XL]

Do you mean..In H3

=G3-IFERROR(INDEX($K$3:$K$6,MATCH(F3,$J$3:$J$6,0)),0)
Copy down

[budvegas]

Ace_XL you are awesome. Thanks for your help!!!!