Lengthy problem - I am in need of help!

P

paultucker79

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.
 
B

bj

I am not sure what you are trying to do.
but have you looked at Vlookup()?
You could potencially use one Vlookup() to determine which "table" You want
to go to
and a second Vlookup() to look within the table.
 
P

Pete_UK

If you have 80 tables, then how do you refer to the tables after the
26th one (Z)?

I would suggest that you number the tables from 1 to 80, rather than
use letters. In this case, the following formula will return the table
number, assuming the number you enter is in cell A1:

=INT((A1-5050)/25)+1

Hope this helps.

Pete
 
Top