Best way to Match Data i.e Vlookup

**johnny_p** · 07-08-2013, 11:52 AM

Hi all

I am have been given a list of approx 1000 names (Multiples & unsorted) and need to match their names to an address I have in another workbook.

The original list has the names in column A and the addresses in Column B.

Is there a way to get the new list of 1000 names to look at the original sheet and match the addresses?

Thanks

Your help is appreciated

**Fotis1991** · 07-08-2013, 11:57 AM

Take a look to INDEX & MATCH functions

**johnny_p** · 07-08-2013, 12:11 PM

Thanks

I have been reading up on this, however I can not see that it will work on a large list. Am I wrong?

**Fotis1991** · 07-08-2013, 12:18 PM

Assuming your big list is in sheet1 columns A:AB.

In sheet2 in column A you have the names and you want the addresses in column B.

So in B1 and copy down use this...

=INDEX(Sheet1!$B$1:$B$10000,MATCH(A1,Sheet1!$A$1:$A$10000,0))

OR else, pls upload a small sample workbook.