maybe a vlookup question
 

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

maybe a vlookup question
 

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))),"fullfil lment",IF(NOT(ISERROR(FIND("Marin",A1))),"Marin"," "))


--
Hope I helped you.

Ciao

Franz Verga from Italy

maybe a vlookup question
 

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" wrote:

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))),"fullfil lment",IF(NOT(ISERROR(FIND("Marin",A1))),"Marin"," "))


--
Hope I helped you.

Ciao

Franz Verga from Italy

maybe a vlookup question
 

Nel post
*arcticale* ha scritto:

"Franz Verga" wrote:

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))),"fullfil lment",IF(NOT(ISERROR(FIND("Marin",A1))),"Marin"," "))

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

maybe a vlookup question
 

Wow, you are really good. the formula worked.

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

"Franz Verga" wrote:

Nel post
*arcticale* ha scritto:

"Franz Verga" wrote:

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))),"fullfil lment",IF(NOT(ISERROR(FIND("Marin",A1))),"Marin"," "))

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