maybe a vlookup question

[Guest]

Hi,

I want to create a column in my worksheet. What this column will tell me is
that whatever text in column A that has the word fullfillment will return
fullfillment to my column, whatever text in column A that has the word Marin
will return Marin to my new column, etc.

What formula do i write in my new column?

thanks everyone,

del

 

[Franz Verga]

Nel post *arcticale* ha scritto:

Hi,

I want to create a column in my worksheet. What this column will
tell me is that whatever text in column A that has the word
fullfillment will return fullfillment to my column, whatever text in
column A that has the word Marin will return Marin to my new column,
etc.

What formula do i write in my new column?

thanks everyone,

del

Hi arcticale,

I think is not a vlookup question...

Lets try with this formula:

=IF(NOT(ISERROR(FIND("fullfillment",A1))),"fullfillment",IF(NOT(ISERROR(FIND("Marin",A1))),"Marin",""))


--
Hope I helped you.

Ciao

Franz Verga from Italy

 

[Guest]

Thanks for replying. The formula is not working. It returns blank. I dont
know what is not working in the formula. Is there another way?

thanks again.

 

[Franz Verga]

Nel post *arcticale* ha scritto:

Thanks for replying. The formula is not working. It returns blank. I
dont know what is not working in the formula. Is there another way?

Thake care... The FIND function is case sentive...

So try this version:

=IF(NOT(ISERROR(FIND("fullfillment",LOWER(A5)))),"fullfillment",IF(NOT(ISERROR(FIND("marin",LOWER(A5)))),"marin",""))


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy

 

[Guest]

Wow, you are really good. the formula worked.

thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!