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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find item in list, return a value
=IF(ISNUMBER(MATCH(A2,Sheet1!A:A,0)),"APPROVED",IF (ISNUMBER(MATCH(A2,Sheet1!B:B,0)),"NOT
APPROVED","")) and copy down. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ladymuck" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find item in list, return a value
Works a treat, thank you!
"Bob Phillips" wrote: =IF(ISNUMBER(MATCH(A2,Sheet1!A:A,0)),"APPROVED",IF (ISNUMBER(MATCH(A2,Sheet1!B:B,0)),"NOT APPROVED","")) and copy down. -- --- HTH Bob |
Reply |
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 |