Match an address to a name
Solved
Scratina
-
Scratina -
Scratina -
Hello,
I searched the site but I couldn't find an answer to my question. I would just like to be able to associate an address with a name.
Let me explain: In sheet 1 of my Excel file, I have a list of contacts, with the names in column A and their addresses in column B. I would like that in sheet 2, when I type a contact's name in A1, their address automatically appears in B1, and similarly for A2 to B2... Is this possible? I already tried to use a VLOOKUP function, but it's not working (it doesn't return the correct row, or it shows N/A). It's very likely that I did not enter the correct formula...
Can you help me?
Thank you
Configuration: Windows / Internet Explorer 10.0
I searched the site but I couldn't find an answer to my question. I would just like to be able to associate an address with a name.
Let me explain: In sheet 1 of my Excel file, I have a list of contacts, with the names in column A and their addresses in column B. I would like that in sheet 2, when I type a contact's name in A1, their address automatically appears in B1, and similarly for A2 to B2... Is this possible? I already tried to use a VLOOKUP function, but it's not working (it doesn't return the correct row, or it shows N/A). It's very likely that I did not enter the correct formula...
Can you help me?
Thank you
Configuration: Windows / Internet Explorer 10.0
1 answer
-
Hello,
In theory, in column B of the second sheet, you need to enter a VLOOKUP:
=VLOOKUP(A1,Sheet1!A:B,2,FALSE)
The N/A means that it has not found anything. We can therefore adapt it to avoid this N/A:
=IFERROR(VLOOKUP(A1,Sheet1!A:B,2,FALSE),"Address Not Found")
Test it and let me know
--
To conquer without peril is to triumph without glory.
Pierre Corneille, Le Cid
