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