Hello,

I'm creating an Excel document that will be used to shorten a process that we are currently doing.

Example - =IF(B9=<'NAMED ACCOUNTS'!G2:G9010,"Named Account","Non Named Account"). This formula NEVER works - it does not have the correct answer - the account I enterend in B9 was a Named Account.

Enter Data in cell
formula in cell below will look to see if entered data matches (completely or partially) data in another spreadsheet, if it does then I need to have the following appear "Named Account" if it doesn't I need the following to appear "Non Named Account".
The problem is that the word being entered may be a partial word and not match the data in the other spreadsheet completely.

I know that this seems a bit confusing but I've been working on this for quite a while and have tried several formulas with no luck.