Vlookup help

[Andrew.Trevayne]

I'm not sure if I should be using Vlookup on this.
So I have datas on Columns A, B and C.
On column A I have names
On column B I have email addresses
On column C I have Phone numbers

What I want to do is on sheet2, i will populate column A with names, then if any of these names has a match on sheet1, it will populate column B and C with corresponding email address and Phone number.

Hope you can help.
(I have enclosed a dummy worksheet)

Thanks in advance.

[Marcol]

With your list of names in Sheet2 Column A, beginning in A2

In B2

Please Login or Register  to view this content.

Drag/Fill Across to Column C
Then both down as far as you need.

This should avoid errors if your data in Sheet1 is not sorted on column A.

If it is sorted then VLookup is fine.

[thirtyeyes]

If you want to use Vlookup on Sheet2 then place this formula in B2:
=VLOOKUP(A2,Sheet1!$A$2:$C$10,2,FALSE)
and this in C2
=VLOOKUP(A2,Sheet1!$A$2:$C$10,3,FALSE)

Data does not need to be sorted in Column A on Sheet1, the FALSE tells it to look for exact match.

[Andrew.Trevayne]

Marcol and Thirtyeyes,
Thanks to both of you for the help.
Both solutions worked and Im going to try to remember them for future use.
Appreciate you help.

Thanks again.