Returning a value from text

[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

 

[Sheeloo]

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

=IF(D3="Sands - over cons. or cemented clayey Sands";"1")

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