Excel Question

T

tampatrader82

Any excel gurus out there that know the equation for this example

Lets say I have a bunch of cells with a bunch of different words in colum A

Excel
Spreadsheet
Computer

You get the idea. In Column b I have a bunch of other words
Spreadsheet
Car
Wallet

In Colum C I would like have a Y put next to any words in column B that are anywhere in column A. In the example above Spreadsheet in Column B should have a Y next to it because it is in column A. I know this is an if, then statement, I am just not what else it is.

Any help would be much appreciated. I hope everyone has a great holiday.
 
Quote from tampatrader82:

Any excel gurus out there that know the equation for this example

Lets say I have a bunch of cells with a bunch of different words in colum A

Excel
Spreadsheet
Computer

You get the idea. In Column b I have a bunch of other words
Spreadsheet
Car
Wallet

In Colum C I would like have a Y put next to any words in column B that are anywhere in column A. In the example above Spreadsheet in Column B should have a Y next to it because it is in column A. I know this is an if, then statement, I am just not what else it is.

Any help would be much appreciated. I hope everyone has a great holiday.
More...

Post this in C1 and then copy it down column C.

=IF(ISERROR(MATCH(B1,A$1:A$1000,0)),"","y")
 
Tampa,

I think this is the result you're looking for:



And here's the formula



If you wanted the "Y" on the other end of the word then switch the arguments to CONCATENATE. The excel file is attached to this post in case you have a problem.

Regards,
Max



__________________
maxdama.com - The log of my research on and implementation of automated trading strategies
 

Attachments

Try something like this in Excel 2007:

=IFERROR(IF(VLOOKUP(Value,Range,1,FALSE)=Value,"Y","N"),"N")

Sort words in Column A in ascending order.

ie. If Column A has words, B has values, C is where you want Y/N

=IFERROR(IF(VLOOKUP(b2,$a$2:$a1000,1,FALSE)=b2,"Y","N"),"N")
 
You must log in or register to reply here.
Back
Top