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=553181

I'm a bit confused.


Both ranges you specify 5050-5074 and 5075 - 5099 are in table A as you
have described it. So what is in Table B?


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553181

Table B has the following values

5024 and Below
5025-5049
5050-5074
5075-5099
5100-5124
5125-5149
5150 and Above


Each following table is an incremental movement of 25 points. The
middle line (in this case 5075-5099) is the line in which the table
revolved around. So if the number I enter is in the range 5050-5074 I
want it to return table "A" (as this is the middle line in table "A")
and if the number I enter is in the range5075-5099 I want it to return
table "B" and so on. Is that clearer?


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

I'm not sure if my post was accepted, this is a check.


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

Hi all

I have had no luck with this, can anyone help? Thanks


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

paultucker79 Wrote:

I have had no luck with this, can anyone help? Thanks

I will help, but the problem is not clear to me. Can you post a sample
of the data on the web and link it here.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553181