Alice_Wong
New Member
- Joined
- Sep 13, 2006
- Messages
- 30
Hi all,
I am working on some data in excel sheet. I need to compare two cells (1 cell and 1 column) in order to get any of the text or numbers that are matched.
For e.g. Cell A1 reads "Apple Pie", I would like to compare Cell A1 with the data i have in Column B. For instance Cell B3 now reads "Pie". So the text that is matched for Cell A1 and Cell B3 is "Pie".
What is the formula that I can use so that I can get the output as "Pie"?
Please help.
Thanks!
Alice[/quote]
I am working on some data in excel sheet. I need to compare two cells (1 cell and 1 column) in order to get any of the text or numbers that are matched.
For e.g. Cell A1 reads "Apple Pie", I would like to compare Cell A1 with the data i have in Column B. For instance Cell B3 now reads "Pie". So the text that is matched for Cell A1 and Cell B3 is "Pie".
What is the formula that I can use so that I can get the output as "Pie"?
Please help.
Thanks!
Alice[/quote]