Lengthy problem - I am in need of help!
 

Hi all

I'm new to this forum but it was recommended to me so I hope you can
help me! My problem is quite long-winded and difficult to explain but
I'll give it a shot.

Basically I have created 80 tables. Each table is a list of 7 numerical
ranges (say covering A1 to A7). I have given each table a name (starting
with "A" and working my way through. To help visualsie this I will tell
you the values in Table "A", below

4999 and Below
5000-5024
5025-5049
5050-5074
5075-5099
5100-5124
5125 and Above



Now, what I want to do is create a formula that will return me this
table if the number I enter in the cell is in the range 5050-5074. If
the number entered is in the range 5075-5099 I would want it to return
the table "B" which I would have created, and is simply a 25 point
upward shift from table "A".

I think I may have tried to over-complicate this but the problem is
that I have 80 tables, with values ranging from 5000 to 7000, and I
can't find the formula to do what I want.

If anyone can help it would be much apprecaited, and of course I will
explain more if you need to me too! Thanks very much in advance.


--
paultucker79
------------------------------------------------------------------------
paultucker79's Profile: http://www.excelforum.com/member.php...o&userid=35559
View this thread: http://www.excelforum.com/showthread...hreadid=553182