Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning a text value using a formula | Excel Worksheet Functions | |||
Returning Text | Excel Discussion (Misc queries) | |||
Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
Values Returning Text | Excel Worksheet Functions | |||
Returning text using a formula | Excel Worksheet Functions |