IF OR problem

[Ksean]

Pete,

Sorry for the data mixup, I actually mixed up two little sample tables I was
working with.

Once I corrected for the < error in the last IF statement, it should have
been > your index formula works great and yes this is going to turn in to one
horrendous formula.

As Phil indicated I think I am going to spend a little time rethinking the
diretion I am going with this formula to see if I can simplify my approach

Thanks,
Kerry

 

[Pete_UK]

Well, I'm glad it worked for you - thanks for feeding back.

It would be a lot easier if you were to list the variations as in your
reply to Brad (including those for U6, U8 and U18) and then use 3
columns to list the date-related values against each combination. Then
you could use a VLOOKUP against this table by concatenating G3 and E3.
The formula would be a lot shorter.

Hope this helps.

Pete