Returning a value from text
=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
"Sam Suffit" wrote:
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
|