vlookup?
 

Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and return
in column B a value

so for example if text 1 has the word fire detection room A i should have in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B gas
detection and so on.
is there anyone that can help with this please?
thanks in advance

vlookup?
 

You mean column B should show the first 2 words of Column A ?

Or you have some other way of relating the 2 columns ?

NickHK

"massi" wrote in message
...
Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and
return
in column B a value

so for example if text 1 has the word fire detection room A i should have
in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B gas
detection and so on.
is there anyone that can help with this please?
thanks in advance

vlookup?
 

Hi NickHK,

ideally it should be a way to relate the two columns.

the formula should see if a particular word is in column A and return an
other word in column B.

if I have for example
Smoke Detection AFT Equipment Roon R8 - Accomodations Upper Deck in column A
i would like to have in column B Smoke Detector (not Detection)
if I have
PESD Manual Push Button On CCR in colunmn A i would like to have Manual push
button in column B








"NickHK" wrote:

You mean column B should show the first 2 words of Column A ?

Or you have some other way of relating the 2 columns ?

NickHK

"massi" wrote in message
...
Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and
return
in column B a value

so for example if text 1 has the word fire detection room A i should have
in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B gas
detection and so on.
is there anyone that can help with this please?
thanks in advance

vlookup?
 

Excel cannot "guess" what you want, so you will have to provide a list
somewhere. At the least, it would need to relate "*Smoke Detection*" to
"Smoke Detector" and "*Manual Push Button*" to "Manual push button".
You will need to make this list.

Once you have that, you can search column A for the "*SomeText*" value, then
return the required value.

NickHK

"massi" wrote in message
...
Hi NickHK,

ideally it should be a way to relate the two columns.

the formula should see if a particular word is in column A and return an
other word in column B.

if I have for example
Smoke Detection AFT Equipment Roon R8 - Accomodations Upper Deck in column
A
i would like to have in column B Smoke Detector (not Detection)
if I have
PESD Manual Push Button On CCR in colunmn A i would like to have Manual
push
button in column B








"NickHK" wrote:

You mean column B should show the first 2 words of Column A ?

Or you have some other way of relating the 2 columns ?

NickHK

"massi" wrote in message
...
Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and
return
in column B a value

so for example if text 1 has the word fire detection room A i should
have
in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B
gas
detection and so on.
is there anyone that can help with this please?
thanks in advance

vlookup?
 

ok. i do my list with the 4 different options for column B.

i guess i need a vlookup to check the value of column A. the question is can
i do a vlookup to check for more than one values?

logically the thing would be :
IF column A contain Smoke Detector THAN put in column B Smoke Detection
IF column A contain Manula push Button THAN put in column B Manual push Button
etc...

the problem is that i don't know hw to do this using the excel formulas


"NickHK" wrote:

Excel cannot "guess" what you want, so you will have to provide a list
somewhere. At the least, it would need to relate "*Smoke Detection*" to
"Smoke Detector" and "*Manual Push Button*" to "Manual push button".
You will need to make this list.

Once you have that, you can search column A for the "*SomeText*" value, then
return the required value.

NickHK

"massi" wrote in message
...
Hi NickHK,

ideally it should be a way to relate the two columns.

the formula should see if a particular word is in column A and return an
other word in column B.

if I have for example
Smoke Detection AFT Equipment Roon R8 - Accomodations Upper Deck in column
A
i would like to have in column B Smoke Detector (not Detection)
if I have
PESD Manual Push Button On CCR in colunmn A i would like to have Manual
push
button in column B








"NickHK" wrote:

You mean column B should show the first 2 words of Column A ?

Or you have some other way of relating the 2 columns ?

NickHK

"massi" wrote in message
...
Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and
return
in column B a value

so for example if text 1 has the word fire detection room A i should
have
in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B
gas
detection and so on.
is there anyone that can help with this please?
thanks in advance

vlookup?
 

it would be THEN not THAN... :-)

"massi" wrote:

ok. i do my list with the 4 different options for column B.

i guess i need a vlookup to check the value of column A. the question is can
i do a vlookup to check for more than one values?

logically the thing would be :
IF column A contain Smoke Detector THAN put in column B Smoke Detection
IF column A contain Manula push Button THAN put in column B Manual push Button
etc...

the problem is that i don't know hw to do this using the excel formulas


"NickHK" wrote:

Excel cannot "guess" what you want, so you will have to provide a list
somewhere. At the least, it would need to relate "*Smoke Detection*" to
"Smoke Detector" and "*Manual Push Button*" to "Manual push button".
You will need to make this list.

Once you have that, you can search column A for the "*SomeText*" value, then
return the required value.

NickHK

"massi" wrote in message
...
Hi NickHK,

ideally it should be a way to relate the two columns.

the formula should see if a particular word is in column A and return an
other word in column B.

if I have for example
Smoke Detection AFT Equipment Roon R8 - Accomodations Upper Deck in column
A
i would like to have in column B Smoke Detector (not Detection)
if I have
PESD Manual Push Button On CCR in colunmn A i would like to have Manual
push
button in column B








"NickHK" wrote:

You mean column B should show the first 2 words of Column A ?

Or you have some other way of relating the 2 columns ?

NickHK

"massi" wrote in message
...
Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and
return
in column B a value

so for example if text 1 has the word fire detection room A i should
have
in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B
gas
detection and so on.
is there anyone that can help with this please?
thanks in advance