lookup and compare
 

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

lookup and compare
 

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

"AndyLee" wrote:

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

lookup and compare
 

hi,
many thanks,

"מיכאל (מיקי) אבידן" wrote:

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

"AndyLee" wrote:

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

lookup and compare
 

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

"AndyLee" wrote in message
...
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

lookup and compare
 

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


"Bill Kuunders" wrote:

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

"AndyLee" wrote in message
...
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


.