| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Searching Across 2 workbooks
I have a column of data in workbook 1 and I have 20 columns of data with 600
rows in workbook 2 I want to search workbook 2 for the data I have in workbook 1 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Searching Across 2 workbooks
What do you mean exactly by search? If you just want to check if a value is
there or not, this formula may work for you: =IF(ISNA(MATCH(A1,[Book1]Sheet1!$A:$A,0)),"Not found","Found") This will search if the contents of cell A1 are found in the A column of the sheet1 of the Book1 workbook, you may change the references as appropiate. Hope this helps, Miguel. "HelpDeskTech" wrote: I have a column of data in workbook 1 and I have 20 columns of data with 600 rows in workbook 2 I want to search workbook 2 for the data I have in workbook 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Searching multiple workbooks | Excel Discussion (Misc queries) | |||
| Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
| Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
| Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Linear Mode
