Skip to main content
Web Applications

Return to Question

added 3 characters in body
Source Link
fini-stair
fini-stair
  • 7
  • 2

Let's say we have a table like below which pairs each name with a colour:

Name Colour
Paul blue
John red

I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then colour is 'blue' etc.

Data Colour
52!Paul*22342 ?
John/23rff ?

Any help would be much appreciated!

Let's say we have a table like below which pairs each name with a colour:

Name Colour
Paul blue
John red

I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then colour is 'blue' etc.

Data Colour
Paul*22342 ?
John/23rff ?

Any help would be much appreciated!

Let's say we have a table like below which pairs each name with a colour:

Name Colour
Paul blue
John red

I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then colour is 'blue' etc.

Data Colour
52!Paul*22342 ?
John/23rff ?

Any help would be much appreciated!

added 37 characters in body
Source Link
fini-stair
fini-stair
  • 7
  • 2

Let's say we have a table like below which pairs each name with a colour:

Name ColourColour
Paul blueblue
John redred

I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then colour is 'blue' etc.

Data ColourColour
Paul*22342 ??
John/23rff ??

Any help would be much appreciated!

Let's say we have a table like below which pairs each name with a colour:

Name Colour
Paul blue
John red

I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then colour is 'blue' etc.

Data Colour
Paul*22342 ?
John/23rff ?

Let's say we have a table like below which pairs each name with a colour:

Name Colour
Paul blue
John red

I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then colour is 'blue' etc.

Data Colour
Paul*22342 ?
John/23rff ?

Any help would be much appreciated!

Source Link
fini-stair
fini-stair
  • 7
  • 2

If cell A1 contains 'john' then cell B1 should equal 'red', if cell A2 contains 'paul' then cell V2 should equal 'blue'

Let's say we have a table like below which pairs each name with a colour:

Name Colour
Paul blue
John red

I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then colour is 'blue' etc.

Data Colour
Paul*22342 ?
John/23rff ?