Find item in list, return a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy rows to another sheet 6
Find a value in a sheet and replace it with another value if it matches 8
VB, Vlookup worksheet function and copying data 1
The query cannot be completed. 1
Find the correct sheet then find a value on that sheet 8
Supressing a #VALUE! error returned? 3
fill in data that is not empty 1
How to Delete rows in a column 2

Back
Top