hello folks, 1st timer here, Well this is my question. I have a range of numbers in two columns, and I would like to be able to for instance say Im looking for a number between 500 - 480, when it locates the number to indicate it in the column next to it with a number 1 0r 2.
this is what im using but Im out in left field and at a loss. The $t$3 and $u$3 cells are the different number ranges that i can change to looking for.
=IF($T$3<=T8,IF($U$3>=U8,1,""))
526 454 answer
510 477 answer
500 477 answer
thanks
This message was edited by Wing-it on 2002-05-08 07:35
this is what im using but Im out in left field and at a loss. The $t$3 and $u$3 cells are the different number ranges that i can change to looking for.
=IF($T$3<=T8,IF($U$3>=U8,1,""))
526 454 answer
510 477 answer
500 477 answer
thanks
This message was edited by Wing-it on 2002-05-08 07:35