Help searching partial or all of data in one cell against entire database in another sheet

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.

Hi

Try
=IF(ISNA(MATCH("*"&B9&"*",'NAMED ACCOUNTS'!G2:G9010,0)),"Non Named Account","Named Account")

If that doesn't do it, then set up an example file with some representative (but not sensitive) data so we can see what you are working with....

rylo

AMAZING - Awesome - THANK YOU! Your resolution worked perfect - What is the best way to gain Excel knowledge? I