Thread Tools Rate Thread

# lookup and compare

AndyLee
Guest
Posts: n/a

 31st Dec 2009
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

מיכאל (מיקי) אבידן
Guest
Posts: n/a

 31st Dec 2009
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

AndyLee
Guest
Posts: n/a

 31st Dec 2009
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

Bill Kuunders
Guest
Posts: n/a

 31st Dec 2009
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

מיכאל (מיקי) אבידן
Guest
Posts: n/a

 31st Dec 2009
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

>
>
> .
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?Q2luZGll?= Microsoft Excel Worksheet Functions 0 24th Mar 2006 06:29 PM matteo Microsoft Excel Misc 0 16th Jun 2005 07:43 PM =?Utf-8?B?TVI=?= Microsoft Excel Worksheet Functions 2 10th Mar 2005 02:59 AM Matt Williamson Microsoft Excel Programming 1 25th Sep 2003 08:54 PM Matt Williamson Microsoft Excel Worksheet Functions 1 25th Sep 2003 08:54 PM

Features

Advertising

Newsgroups

All times are GMT +1. The time now is 10:04 PM.