Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) | Excel Discussion (Misc queries) | |||
Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) |