Excel 2007

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
 
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup function to ignore blanks 1
Unique Entries 10
formula to pull names out of list 3
Pivot tables 2 row labels 4
Lookup to create List 3
Simple EXCEL worksheet function 1
How do I compile data? 4
invoice on sheet 1 & data store on sheet 2 automatically 2

Top