Probably a simple task though amateur struggling

[Watsoa]

Please could someone help me out with a little problem i have.

I currently have a table A1:B5 in which column A reads values 10-20-30-40-50 and column B reads S/M/L/XL/XXL

I want a function so that if the user inputs 15 into a cell, it will look-up into the table and match to the next size up.....ie, 15 would match to 20 and display M.........37 would match to 40 and display XL....41 would match to 50 and display XXL.

Currently have been trying IF/AND though im tying myself in knots

Hope someone can help me out, much appreciated A.

 

[AlphaFrog]

If you're able to have the size limits be minimums instead of Maximums, then you could use a simple VLOOKUP function...

Excel Workbook
	A	B	C	D	E
1	0	S		15	M
2	10	M
3	20	L
4	30	XL
5	40	XXL
6	50	Too Big
...

Cell Formulas
Range	Formula
E1	=VLOOKUP(D1,A1:B6,2,1)

 

[Watsoa]

Ahhh, i hadnt thought of it like that. Brilliant, makes it a whole lot easier.

Thanks muchly

 

[Peter_SSs]

Perhaps I've mis-understood, but doesn't that give an incorrect result when the lookup value actually occurs in the table? For example, it returns "L" for a lookup value of 20. Shouldn't it return "M" for 20?

If so then since your size gaps are all 10, I'd suggest the formula in E1. If the size gaps were not even, then you could use the formula in F1.

Excel Workbook
	A	B	C	D	E	F
1	0			20	M	M
2	10	S		25	L	L
3	20	M		3	S	S
4	30	L		48	XXL	XXL
5	40	XL
6	50	XXL
Lookup