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.