lookup with match

[stacy.burk]

In Sheet 1, I have a list of employees in one column and their SS# in
another column. In Sheet 2, their is a list of employees names that
will not include all the employees in Sheet 1. I would like to match
the employee names on the two sheets and have the correct SS# input
into a column beside the employee name in Sheet 2. I hope that I have
explained myself fully. Thanks for any help!

 

[Roger Govier]

Hi Stacy

assuming there are no duplicate names, enter in B1 of Sheet2
=INDEX(Sheet1!$A:$B,MATCH(A1,Sheet1!$A:$A,0),2)
and copy down as required.

 

[xlmate]

try this formula

Let say in Sheet1 Col A contain Employee Name and Col B contain #SS no.
And that, Sheet2 col A listed the employee names

Place this formula in cell B2 of Sheet2 and copy down

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

or this to replace #N/A to "not found"
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$8,2,0)),"not
found",(VLOOKUP(A2,Sheet1!$A$2:$B$8,2,0)))

Pls note that this is one single line.

Does this do what you want?

HTH

--
======================
Pls click Yes if this has help you
======================

Thank You

cheers,

 

[stacy.burk]

Thanks for the information - it is working great!

 

[xlm]

Thanks for the feedback, and is glad to have assisted



cheers,

========================
please click the Yes button if this help
========================