If statement in Excel looking for text

xmtler Posts 1 Registration date Sunday November 22, 2009 Status Member Last seen November 23, 2009 - Nov 23, 2009 at 01:31 PM
 Conner - Apr 29, 2011 at 04:12 PM
I have a column with 3 text labels (book, pencil, eraser). I want to create a new column where I can find cells in the original column that have either "pencil" or "eraser".

Thanks in advance.


1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 23, 2009 at 08:17 PM
see whether you can do this
highlight column A (this column should heave column heading)
click date(men bar)-filer-autofilter
there will be small arrow in the column heading of column A
click that arrow
click "pencil" in download list
you will get pencil filtered. highlight the visible cells and copy anywhere
click <all> in the download box
again repeat same steps for eraser.
lastly click date-filter-autofitler
the filter will be removed.
I would try =IF(cell range="book". book, IF(cell range="pencil", pencil, IF(cellrange="eraser", eraser, none)))

That was just a quick shot, you will need to play with the parenthesis.

Hope this helps.