Excel 2007
 

I have 2 worksheets that have Company Name on both. 2nd worksheet has a
unique id for each Company Name that I need to pull over to worksheet 1 if
there is a match between the 2 worksheets. If Sheet 2 company name matches
Sheet 1 company name, I then need to list on Sheet 2 the unique id for the
company name.

Sheet 1
Company Name Unique ID

Sheet 2
Company Name

Excel 2007
 

Hi Krista

Try the below formula in Sheet2 cell B1 with company name in cell A1

=IF(COUNTIF(Sheet1!A:A,A1),VLOOKUP(A1,Sheet1!A:B,2 ,0),"")

--
Jacob


"Krista" wrote:

I have 2 worksheets that have Company Name on both. 2nd worksheet has a
unique id for each Company Name that I need to pull over to worksheet 1 if
there is a match between the 2 worksheets. If Sheet 2 company name matches
Sheet 1 company name, I then need to list on Sheet 2 the unique id for the
company name.

Sheet 1
Company Name Unique ID

Sheet 2
Company Name