Unclear. You are matching C2 in col E? and C3 in col B? What are you matching
exactly? You have no reference to what is in column E, and column B has 2
values that you show. More detail is needed. And perhaps what a desired
output would be for a given sample table.
--
John C


"Haz" wrote:

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