LinkBack URL
About LinkBacks
I'm using to cross reference two sheets. One contains all my customers email addresses, the other contains a list of email address that were not supposed to email.
Please Login or Register to view this content.
I'm using to cross reference two sheets. One contains all my customers email addresses, the other contains a list of email address that were not supposed to email.
Please Login or Register to view this content.
Last edited by djarcadian; 12-14-2013 at 02:38 PM. Reason: Realized I had the wrong sheet reference but I'm still getting an error.
Whats it doing that it's not supposed to be? What version of excel are you using? maybe you could simplify this a bit with iferror()?
=IF(iferror(VLOOKUP(A3,DoNotEmaii!$A$1:$AA$1000000,16,FALSE),iferror(VLOOKUP(A3,AccountList!$A$1:$AA$1000000,16,FALSE),""))
(untested)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I'm just getting a general error. I was doing this in Google Sheets but also tested it in Excel 2007 and got the same general error. "The formula you types has an error"
I tested your code too and it didn't work.
OK its hard to work blindCan you post a sample and show what you expect please?
https://docs.google.com/spreadsheets...it?usp=sharing
I've made this public so you should be able to access it. On the "Front" sheet find the code in E3. You can see the more basic lookup in D3.
To expand on what I wrote.
The AccountsLlist is a list of all our customer accounts with names and email addresses.
The DoNotEmail sheet contains a list of Accounts that do not wish to receive emails from us.
The Front sheet column E should contain a list which compares the AccountsLIst and DoNotEmail list and will only shows the filtered list (people who want emails).
If you check the D3 cell on the Front sheet you'll see that the Vlookup works to find a particular accounts email address. You can modify that by switching it to show the DoNotEmail sheet.
I tried to use the IF statement to compare the two so it only shows emails for Accounts that want to receive email addresses.
This will check both worksheets for a match and if not found will return a blank cell.
Formula:
Please Login or Register to view this content.
This will lookup the value in A3 and if found on the DoNotEmail list will return the value in column 16 otherwise it will return a blank cell
Formula:Please Login or Register to view this content.
This will lookup the value in A3 and if found on the AccountList will return the value in column 16 otherwise it will return a blank cell
Formula:Please Login or Register to view this content.
OR
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Close at request of OP, new thread was started in Commercial Services.
http://www.excelforum.com/commercial...-sure-why.html
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks