H
Haz
Hello,
I have data arrange as this,
b2 c2 D2
1 2 3 ........17
B3 C3 D3
0 2 5 ..........15
Using the above criteria i would like to match C2 in col E then
corresponding C3 with col B and if number in Col B is below that of C3 then
return ''out' if over ''on target''
Hope this clear, I have tried this with an IF function but can't get it to
work?
Any help would be appreciated.
Thanks
I have data arrange as this,
b2 c2 D2
1 2 3 ........17
B3 C3 D3
0 2 5 ..........15
Using the above criteria i would like to match C2 in col E then
corresponding C3 with col B and if number in Col B is below that of C3 then
return ''out' if over ''on target''
Hope this clear, I have tried this with an IF function but can't get it to
work?
Any help would be appreciated.
Thanks