V-lookup help

[Proteus]

I have to reach out to this forum as I've hit a brick wall (brick wall being, simply not enough smarts!). I'm thinking V-look up or Match but not really sure how to achieve the desired result.

In the layout below I want retrieve from sheet 1, the person for each address.
Note: In the actual data, multiple persons control multiple addresses. But only one person controls multiple addresses in this example. Sheet one lists only unique addresses in column A along with the person who controls that address (however, each address contains multiple entities - that are not shown in this data - which is why addresses are separated in sheet 2).

In sheet 2, I want to retrieve into column B the person who controls the address next to each separated address.

Thanks in advance for any help.

Sheet 1 ---
Col A - Col B
Address 1 - Person A
Address 2 - Person A
Address 3 - Person B
Address 4 - Person A
Address 5 - Person C

Sheet 2 (showing desired result) ---
Col A - Col B
Address 1 - Person A
Address 1 - Person A
Address 1 - Person A
Address 1 - Person A
Address 2 - Person A
Address 2 - Person A
Address 3 - Person B
Address 3 - Person B
Address 3 - Person B
Address 3 - Person B
Address 3 - Person B
Address 4 - Person A
Address 5 - Person C
Address 5 - Person C

 

[pdevito3]

Try putting this in Sheet2 A1 and then double click the autofill box

=VLOOKUP(A1,Sheet 1!A:B,2,FALSE)

 

[bschwartz]

Try this:

=VLOOKUP(A2,Sheet1!$A$2:$B$999,2,0)

 

[Proteus]

Thanks Paul this works perfectly. Now I just have to translate the column/cell names back to my massive sheet! Thanks for your help.

Try putting this in Sheet2 A1 and then double click the autofill box

=VLOOKUP(A1,Sheet 1!A:B,2,FALSE)