a look up question

[Guest]

I asked yesterday but now I dont see my posting.

My question is : I am trying to create a new column where this new column
will contain a one word text extracted from the first column. Example, I want
to have my second column to show the word warehouse for all those rows in my
first column that have the word Warehouse. The word warehouse in the first
column are in different position. Then, all rows that have the word
fullfillment in the first column will have the one word fullfillment in the
new column. Again, the word fullfillment is in different position. I have
various of this type in a huge spreadsheet.

Will greatly appreciate all your help.

thanks,
del

 

[Guest]

Someone replied to your previous post already. You can find it at
http://www.microsoft.com/office/com...87c1&mid=9dc73cb0-5a5c-4d2d-841c-6a0e437f850c

You can also view your most recent postings by:
1. click the "edit profile" link (between the "sign out" link and the "help"
link) to go to your profile page
2. scroll to the bottom of your profile page and click on the "preview" button
3. on the pop up window, click the "recent posts by this user" link, and
your original window will show all your recent posts

-Simon

 

[Otto Moehrbach]

If your data is in Column A starting with A1, enter this formula in B1 and
drag it down as far as your Column A data goes. HTH Otto
=IF(OR((A1="warehouse"),(A1="fullfillment")),A1,"")

 

[Guest]

the formula doesnt work because the word i am looking for in column a are
mixed up with other texts e.g. 101 warehouse, warehouse 2, Napa warehouse,
Napa fullfillment, marin fullfillment, etc.

Do you know other formulas that might work?

thanks