Hello! I am a newbie and I need some help.
So here is the problem.
I have a list of cooperatives in one excel file.
In another excel file, I have a list of companies.
I want to know if a certain cooperative is a company.
So I made a formula with a lookup with a search function. So that it could look in the excel file with the list of companies and search it in the excel file with cooperatives and say "yes" if that company is a cooperative.
This is my current formula, =LOOKUP(2,1/ISERROR(SEARCH([Book1.xlsx]Sheet1!$A$1:$A$16198,B13)),"Yes")
Note: My cooperative list has about 20295 entries, so I copied the formula 20295 times. So that
=LOOKUP(2,1/ISERROR(SEARCH([Book1.xlsx]Sheet1!$A$1:$A$16198,B13)),"Yes")
=LOOKUP(2,1/ISERROR(SEARCH([Book1.xlsx]Sheet1!$A$1:$A$16198,B14)),"Yes")
=LOOKUP(2,1/ISERROR(SEARCH([Book1.xlsx]Sheet1!$A$1:$A$16198,B15)),"Yes")
=LOOKUP(2,1/ISERROR(SEARCH([Book1.xlsx]Sheet1!$A$1:$A$16198,B16)),"Yes")
=LOOKUP(2,1/ISERROR(SEARCH([Book1.xlsx]Sheet1!$A$1:$A$16198,B17)),"Yes")
=LOOKUP(2,1/ISERROR(SEARCH([Book1.xlsx]Sheet1!$A$1:$A$16198,B18)),"Yes")
and so on.
The problem is that all of the cells with my formula, display the error #VALUE! and I don't know how to fix it.
Regards and Thanks in Advance.
Bookmarks