| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find item in list, return a value
Sounds simple but I'm having trouble!
I have two columns in a worksheet, cell A1 has the value APPROVED, cell B2 has the value NOT-APPROVED. Under these headings are lists of websites. On another worksheet, I have a total list of all websites visited over a period and the number of times that site has been visited. I want to add another column that looks at the first worksheet, finds the site name and returns APPROVED or NOT-APPROVED according to what column it is in. How do I do that? It's all part of a bigger macro that I've got running but am happy with either a formula or code hint. Many thanks for your suggestions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
| Return a value if item does not appear on list | Excel Worksheet Functions | |||
| Select an item from dropdown list but return value from adjacent c | Excel Discussion (Misc queries) | |||
| How do I return a value by clicking an associated list box item | Excel Worksheet Functions | |||
| find item in list | Excel Programming | |||
Threaded Mode
