using lookup function with or function

[ry94]

So on my spreadsheet, I have 2 columns of 1000+ names of partners, which is organized into creating partners and developing partners. On my other spreadsheet, I have a list of about 100 partners or so, and I want to lookup if any of the names that are in either one of the 2 columns of the 1000+ partners are found in the column of the 100 partners. If it is found in either column, I want it to say "true" in the cell I want, otherwise "false". So I've been trying to use a Lookup and an Or function, but am currently just getting #value so any help would be great. Hopefully it makes sense, I'll try to create a small example below.


Sheet 1 Sheet 2
Creating partners Developing partners partner 1
partner 1 partner a partner b
partner 2 partner b partner 3
partner 3 partner c

[ry94]

well that example came out sloppy

[FDibbins]

Hi and welcome to the forum

Maybe something like...
=iferror(1st-vlookup,iferror(2nd-vlookup,False)

[ry94]

Hmm, so that formula didn't work for me, but it's most likely just because I'm putting it in wrong, I'm not terribly experienced with excel. So I'll try to put in a small example of what my spreadsheet looks like.
partner spread sheet example.xlsx
So hopefully that worked. If you're seeing it correctly,I have creating partner, and developing partner columns which are highlighted, and I want to lookup if any of the partners that are located in those two columns appear in the partner column on sheet 2.If they do, I want it to say true in the active partner column on sheet 1, if not, false. If anyone could give me extremely specific formulas that I could possibly just copy and paste, I will love you forever and once I become of age, I will for sure buy you a frothy alcoholic beverage