Returning a value from text
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 |
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 |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com