VLOOKUP a cell reference using < and >

[David Lipetz]

In sheet "Stat1", each cell in column C contains a whole number from 1-50.

In sheet "Stat2", column A contains a letter and columns C & E are used to
create a numeric range. Each letter in Col A is a coder representing the
range specified in cols C & E.

For instance:
A C E

A 1 2
B 3 5
C 6 9
D 10 15

I would like to use VLOOKUP (or whatever is appropriate) to find the
appropriate letter code (from Stat2 col A) which represents the numeric
range (Stat2 cols C & E) for the number in Stat1 col C. The result will be
placed in Stat1 col D.

Example:
If a row in Stat1 col C = 4, then "B" will be the result displayed in col D
as 4>3 and <5 and therefore falls into range "B" identified on Stat2.

Ideas?

Thanks,
David

 

[Peo Sjoblom]

You should really use a different layout, no need to use 2 columns for the
number range, if instead you would use

A C

A 1
B 3
C 6
D 10



then you could use


=LOOKUP(C2,Stat2!C2:C20,Stat2!A2:A20)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[David Lipetz]

I don't think this will work.

What if the value of C2 is 2?

 

[David Lipetz]

Never mind my last post, your formula does indeed work.

Thanks!