lookup and compare

[AndyLee]

hi, i want to insert a lenght into a cell and have another cell display a
size required based on a size range: say lenght 138cm gives size2 100-149cm

input cell output cell
Lenght: 138cm you require a: size2

A B C
1 size1 50 99
2 size2 100 149
3 size3 150 199
4 size4 200 249

 

[מיכ×ל (מיקי) ×בידן]

Check out this:
http://img198.imageshack.us/img198/5046/nonameyi.png
Micky

 

[AndyLee]

hi,
many thanks,

Check out this:
http://img198.imageshack.us/img198/5046/nonameyi.png
Micky

 

[Bill Kuunders]

set up your table

0 too small
50 size1
100 size2
150 size3
200 size4
250 too large

and use the formula
=VLOOKUP(L1,M1:N6,2,TRUE)
where the table sits in M1:L6
L1 is the cell you enter the length
2 is the second column of the table
TRUE will cause to look to the nearest

greetings from New Zealand in 2010

 

[מיכ×ל (מיקי) ×בידן]

Normally, in such cases, you may omit the TRUE because this is the default.
"Happy new year" [it is exactly midnight here].
Micky