| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a list, where I can look-up a corresponding value
Im am trying to set a system where you would have to example:
Date Data Range Relevent Location 29/10 10 - 20 1 30/10 21 - 42 2 I want to know if I can set a formula in excel to be able to set the data range (with specific unique values) so that if I look up say data value 19, it will tell me the location is 1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
| I do not have the List-create a list option on my data toolbar ?? | New Users to Excel | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
Threaded Mode
