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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks