| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to lookup a value within a range and return a label
Wrecking my head this one:
For example if the Label A is from 1 to 200 B from 201 to 1000 C from 1001 and above How can I lookup and return the correct label for a value. Is there a function for this, or does it require programming |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to lookup a value within a range and return a label
Put these values in cells A1:B3
1 A 201 B 1001 C put the value to look up in C1, and use this formula =VLOOKUP(C1,A1:B3,2) "jocmccoy" wrote: Wrecking my head this one: For example if the Label A is from 1 to 200 B from 201 to 1000 C from 1001 and above How can I lookup and return the correct label for a value. Is there a function for this, or does it require programming |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a range of cells from a vertical lookup | Excel Worksheet Functions | |||
| lookup and return range of cells | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
Linear Mode
