Here is the formula I'm at now:
{=IF(U2='160379'!$P$5:$R$18,IF(NOT(Dept160!S2<'160379'!$B$5:$D$18+'160379'!$H$5:$J$18),IF(NOT(Dept160!S2>'160379'!$B$5:$D$18-'160379'!$H$5:$J$18),TRUE,""),""),"")}
It doesn't work...but I want it to! =P
What I'm trying to do...I want it to match up with an identifier (U2='160370'!P5:R18), then I want it to check for ouliers by checking if S2 is greater than or less than '160379'!B5+-H5, and give TRUE if it is outside that range and "" if not. However, I most likely am screwing up because I have three columns that I am looking at...and I want excel to know that if you find the match in one of the columns, then go left or right that many columns and use those numbers. So to say....my identifiers are in columns P,Q,and R. I have three other columns with the Averages (B,C,and D), and then three other columns with the StDev (H,I,and J). I want to have my formula check the identifier and match, then if that value is in ...say P, then it will check if S2 is > or < B5+-H5 ...say Q, then it will check if S2 is > or < C5+-I5 ...say R, then it will check if S2 is > or < D5+-J5. Maybe I'm being too greedy in one formula. Can you help Aladin? If you need to see more, I'll email an example.
Thanks