Excel 2007

[Krista]

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

 

[Jacob Skaria]

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),"")