Query A2 to find value of B2

Howdy, columnA represents statistics that are unrelated to columnB but there is a need
to determine what the number is in columnB by querying columnA to get it. It goes like
this: say I entered "17" in C1. The formula in C1 would find 17 at row A5 and put a 1(B5)
in D1. Or if the number entered was 27 (A8) then put 4 (B8) in D1.

Please Login or Register  to view this content.

thanks,I've tried everything that doesn't work....if this can be done witout vb that would be great.

sktneer...That does exactly what I had in mind. I see problems with my thinking though.....lol. I will tinker with this to see if I can get it to do other things too. Will probably need to start a new thread.
Thanks very much....By the way, If I had asked this question in the "Commercial" forum, how much would it have cost for the answer?

We are off to the races....thank you very much.