|
|
#1
11-10-2016, 05:56 AM
|
|||
|
|||
VLOOKUP Email address
Hi
This is in relation to a previous post https://www.msofficeforums.com/mail-...rge-excel.html I got the above to work by installing the addon now all i have left is to add email. What i have done so far is i added a new colum with the email. I need a formular/funktion that searches for matches in a diffrent table for the right email then list how it in the same row as the agent. I don't know if VLOOKUP is the right funktion 
|
|
#2
11-10-2016, 06:07 AM
|
|||
|
|||
|
example
=VLOOKUP([Agent];Tabel1[Email];Tabel1[Agent];FALSE) Table Agent has all the agents name Table1 Email and agent has all the agents with their emails Last edited by GenzoDK; 11-10-2016 at 06:07 AM. Reason: adding tekst
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| changing email address and put email back to server | solquest3 | Outlook | 2 | 09-22-2016 11:57 PM |
| Hide Email Address of Previous Email when Replying or Forwarding | bondingfortoday | Outlook | 0 | 03-05-2016 04:29 PM |
| Add link to email address that hides the actual address or makes it inaccessible to online bots | richiebabes | Word | 1 | 09-03-2014 03:22 PM |
| Mail Merge Many URLs in one email by common email address | instantaphex | Mail Merge | 3 | 04-29-2013 05:46 PM |
 Outlook won't reply/forward email from one email address
|
rluna68 | Outlook | 2 | 01-07-2013 12:42 PM |
Windows 7 64bit 
Office 2016
Linear Mode
