Excel 2007

  • Thread starter Thread starter Krista
  • Start date Start date
K

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