General Topics
Markets
Technical Topics
Brokerage Firms
Community Lounge
Site Support

# Excel Question

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
Computer

You get the idea. In Column b I have a bunch of other words
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.

2. ### LuckyGirl

The lookup function will do what you want.

3. ### Shreddog

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

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

4. ### maxdama

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

File size:
16.5 KB
Views:
73
5. ### PocketChange

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")