Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lookup and compare cells? | Excel Worksheet Functions | |||
Lookup and Compare | Excel Discussion (Misc queries) | |||
Case Sensitive Compare, Lookup, etc???? | Excel Discussion (Misc queries) | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Lookup and compare rows | Excel Worksheet Functions |