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" 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

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

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" <(E-Mail Removed)> wrote in message
news:2B6CD3F3-5869-43CE-AA63-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:2B6CD3F3-5869-43CE-AA63-(E-Mail Removed)...
> > 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
>
>
> .
>