How to use If Statement or Vlookup when comparing lists of names

[Dprobasco]

I have a spreadsheet with three worksheets

The first worksheet contains a list of 5045 names of people in one column and related individual ID numbers in another column

The second spreadsheet has a list of 345 names of people in a column

The third spreadsheet has a list of 200 names of people in a column

For each of the second and third spreadsheets I want to compare that list to the longer list and when it matches, put the related ID number in the next column.

Which is better to use, the If statement or the Vlookup statement.

How would I use the statement to make it work.

I tried the if statement but ended up with the Spill error message

Dale

 

[Dprobasco]

Thanks for the previous help.

Another question and is similar.

If I have a spreadsheet with a list of just volunteer names in column A and their respective ID number in column B of worksheet one and a list of client and volunteer ID numbers in column A of worksheet 2. How could I have Excel compare the ID numbers in worksheet 2 column A and when it finds a match of ID numbers copy the name of the volunteer with that ID number from worksheet one into column B of worksheet two next to the matched ID number

Dale

 

[Peter_SSs]

Something like this?

Dprobasco.xlsm
	A	B
1	Volunteer	ID
2	Tom	ID1
3	Ann	ID55
4	Jen	ID8
5	Bob	ID3
6	Ken	ID6
Sheet1

Dprobasco.xlsm
	A	B	C
1	Client	ID	Volunteer
2	Client 3	ID3	Bob
3	Client 8	ID8	Jen
4	Client12	ID12	Not found
5	Client 1	ID1	Tom
Sheet2

Cell Formulas
Range	Formula
C2:C5	C2	=XLOOKUP(B2:B5,Sheet1!B2:B6,Sheet1!A2:A6,"Not found")
Dynamic array formulas.

 

[Dprobasco]

Thank you so much. It is unbelievable how helpful this forum is and how quick everyone responds.

Before you know it I will move from beginner to strong beginner.

Thanks.

Dale

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

Before you know it I will move from beginner to strong beginner.

.. and then answering questions in the forum.