| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do look up with restrictions
I am trying to create a lookup on another workbook, I want it to look up
items under certain categories. I currenlty have the following A b c Carrots Produce $1.00 Wrap Paper $.15 Etc. Colum A is the item I want to look up, but I only want it to show items under one category i.e. Paper. Is this possible, if so anyone have any ideas or a formula that would work? Any help would be apprecited. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restrictions on size of XL file? | Setting up and Configuration of Excel | |||
| Connect columns, with restrictions | Excel Worksheet Functions | |||
| character restrictions when importing data from a text file | Excel Discussion (Misc queries) | |||
| Cannot access internet from taskpane due to computer restrictions | Excel Discussion (Misc queries) | |||
| Subtract time and dates with restrictions | Excel Worksheet Functions | |||
Threaded Mode
