Returning a value from text

  • Thread starter Thread starter Sam Suffit
  • Start date Start date
S

Sam Suffit

Hello everybody there,

i want to return a value for the cels in one column in corresponding cels in
an other column
the situation looks as follows:

bla bla 1
bla bla 1
bla bla 1
bla bla 1
ohlala 2
ohlala 2
ohlala 2
ohlala 2
ohlala 2
ohlala 2
tiens 3
tiens 3
bla bla 1
bla bla 1
bla bla 1

=IF(B2="bla bla";"1";ALS(B2="ohlala";"2";ALS(B2="tiens";"3")))

When i try the same with text like
for example
Sands - over cons. or cemented clayey sands
=IF(D3="Sands - over cons. or cemented clayey Sands";"1")
this doesn't work
i get a return UNTRUE

can somebody help me?

thanks


Sam Suffit
Belgium
 
=IF(B2="bla bla";"1";ALS(B2="ohlala";"2";ALS(B2="tiens";"3")))
=IF(D3="Sands - over cons. or cemented clayey Sands";"1")
Click to expand...
Both of the above have TEXT to compare with...
Most likely - or . in the text are creating problem for you... try to remove
them and test.

Also for your requirement use VLOOKUP like
=VLOOKUP(D2,A:B;2;False)
to get the value corresponding to D2 in Col A from Col B
 
Back
Top