I use vlookup all the time for work, but for some reason, it won't work for email addresses. What we do is we export data from a program into Excel and then we use vlookup to make sure our suppliers are in our commodity for our workload that day. This is done by selecting the supplier numbers, and then the array is the supplier number, the name of the suppler, and then the commodity, then in the next field we enter three, then next field false. Makes sense, right? So I've used this formula for everything, but it won't work with email addresses.
I'm thinking it has something to do with the formatting, but no matter what I do it won't work. Has anyone had any success using a lookup function for email addresses? It would really be appreciated!
Thanks in advance for your time!
Answers & Comments
Verified answer
Hi,
Try something like this:
=HYPERLINK("mailto:" & VLOOKUP(), VLOOKUP())
Note: Replace VLOOKUP() with your current VLOOKUP formula.
1
I just tried https://tr.im/V6IhC last year to see if I could Locate my birth-father. My bio father left me when I was 7, and has refused to be a part of my life since. I grew up with my bio Mother and Step-father. I have only ever talked to my biological father a couple times until now. All I knew of him personally when I conducted the search was his first name, last name, and the street address of a previous address he used to have.
When the search results came back based on the minimal info I had, It pulled up a recent address along with even a phone number. When I called the phone no., I heard the voice of what sounded like it may be my step-brother. I asked if Joseph(my biological dad) was there, and he said no but to try back after 5.
I haven't done anything with the info, But I found what I was wanting to have.
removing it is fairly easy, right click > remove hyperlink. to stop excel from putting it to start with Tools > Autocorrect Options. Select the AutoFormat As You Type tab. Uncheck the box for adding hyperlinks. This will stop excel from putting the hyperlinks in the first place. note: above menu option is for Excel 2003. Excel 2007 has this option as well but I don't remember where you find it. Search F1 (help) to find out where it's located.
For the best answers, search on this site https://smarturl.im/aDQuw
This is the best option for a reverse phone number lookup https://tr.im/721a7
Receiving a one or two hang up calls each month is probably nothing to worry about, but when those calls increase in frequency and if it happens in the middle of the night then you must do something to stop it, before it starts affecting your life. With the help of this services you can take away the one advantage these people have - their anonymity.
Criminal Records Database: https://tr.im/m4clG
Public records are named so because these are records that are meant to be obtained by public and when you say "public", it could be anyone. Public records can be used by anyone for investigations and other things like genealogy, verifications, and free background check. When you say it is public, there is no need to ask permission to the person who is named on the records or the person that you are investigating. You also do not need to ask permission from the government if you want to obtain such records by social security number. All you have to do is to visit them and follow the process of requesting the public records and then wait for the records to be ready for pick up. Once you already have the records that you need, you are now ready to perform a free background check.
I just tried https://tr.im/sq2zI last year to see if I could find my paternal father. My bio father left me when I was 8, and has refused to speak to me since. I grew up with my bio Mother and my Step-father. I have only ever met with my biological father a couple times to date. All I knew of him personally when I conducted the search was his full name, and the home location of a previous address he used to have...