We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

I need to change a cells value if a corresponding value is found in a seperate worksheet.  I don't know how.

104 Views
Last Modified: 2017-04-05
I have a report due monthly that depends on the values found in several worksheets.

DomainList:  includes all domains and domain aliases in the account.
AliasList: is a filtered list of just the domain aliases.

In the report I have a column titled Type which can have a value of either "S" or "A" depending on if it is a site or an alias.
Type is determined by finding a domain name in the alias list (or not).
I think the question I need to ask is:

If "DomainList:domainname" is found in AliasList:domainname then type = "A"
If "DomainList:domainname" is NOT found in AliasList:domainname then type = "S"

How do I do this in VBA?
sampledata.xls
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Those three little lines will save me tons of time....  Thank you!   I hate that I read the help files and don't recognize when and how to use this code.  That is why I am so thankful that you guys are here!

David
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.