Creating a Table that Passes Specific Column Values

[Merkb7661]

Hello All!

I'm familiar with the basics of Excel, but it's not a tool I have ever used to this degree, so I need some help! Assume I'm a hobbyist C++ developer, but not necessarily familiar with the syntax and formatting of Excel formulas, so treat me thusly.

I am creating a spreadsheet with 4 columns. Each column contain a line of text copied from a txt document, and looks like this:
Error: Out of Gamut, GelName, Gel123, GelType

All text, single cell. Four columns of that, each column dedicated to a single device that contains each gel. Now, I want to have a cell where I can type in the name of "Gel123", and it will search for that text in each column. If all columns contain that text, it will return True. If none of the columns contain that text, it will return false. I have tried this, and got it working, with two columns, using this code in column G: =IF(AND(COUNTIF(A:A, "*"&G2&"*")>0,COUNTIF(C:C, "*"&G2&"*")>0),"TRUE","FALSE")

Great! But what I need is ever so much more specific. I need it to perform the check in all four columns, and then return the results of WHICH columns contain it, specifically. I'd like to reference those columns by a name I select, like "Device 1", rather than A,B,C, etc..

Thanks guys and gals! If you can help me with this, I'll be a hero to the team I'm working on.

-Brandon

[Pete_UK]

It would help if you attached a sample Excel workbook, as it is not clear where "Device 1" fits in to the description you have given.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it is broken on this forum.

Hope this helps.

Pete