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