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.

	A	B	C	D			
1	14	6
2	25	2
3	11	2
4	4	7
5	17	1
6	32	3
7	12	6
8	27	4
9	1	5
10	3	8
11	23	2

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.