To select from 4 options(cant use if)

[zoharb]

Respected,
I have to display answer based on the data in teh previous column(its in text-general , not number),
I cannot use if.
Zohar Batterywala
zoharsb@gmail.com

 

[Aladin Akyurek]

Respected,
I have to display answer based on the data in teh previous column(its in text-general , not number),
I cannot use if.
Zohar Batterywala

[...]

A bit more information would be helpful. Judging from what is provided, here is an example:

=INDEX($B$2:$B$100,MATCH(K2,$F$2:$F$100,0))

This matches K2 against F2:F100 and returns a corresponding value from B2:B100 as result.

 

[zoharb]

ALADIN Akyurek SIR,
On the basis of data in Column
E(Open)
Column F(high)
Column G(low)
Column H(close/Last)

Value in col V and Column W are calculated

They can be

In col V
(1)OH(Open high)
(2)OL(Open Low)

In col W
(1)HC(High Close)
(2)LC(Low Close)

On basis of that, the value in Col X has to be calculated

Case
(1)OHLC OR OLHC-difference of E(OPEN)-H(Close)
(2) Only OH (no LC or HC in Col V)
X has to be E-H , F-G
(3) Only OL (no LC or HC in Col V)
X has to be E-H , G-F

Now if there can be a case where in IF initially negating OHLC/OLHC,
I go to the second step,and then do "ONLY OL" STEP or "ONLY OH" step but that makes things complicated for debugging it at later time so I do not want to go in IF.
Zohar Batterywala
zoharsb@gmail.com

 

[zoharb]

A bit more information would be helpful. Judging from what is provided, here is an example:

=INDEX($B$2:$B$100,MATCH(K2,$F$2:$F$100,0))

This matches K2 against F2:F100 and returns a corresponding value from B2:B100 as result.

----------------reply--------------
ALADIN Akyurek SIR,
On the basis of data in Column
E(Open)
Column F(high)
Column G(low)
Column H(close/Last)

Value in col V and Column W are calculated

They can be

In col V
(1)OH(Open high)
(2)OL(Open Low)

In col W
(1)HC(High Close)
(2)LC(Low Close)

On basis of that, the value in Col X has to be calculated

Case
(1)OHLC OR OLHC-difference of E(OPEN)-H(Close)
(2) Only OH (no LC or HC in Col V)
X has to be E-H , F-G
(3) Only OL (no LC or HC in Col V)
X has to be E-H , G-F

Now if there can be a case where in IF initially negating OHLC/OLHC,
I go to the second step,and then do "ONLY OL" STEP or "ONLY OH" step but that makes things complicated for debugging it at later time so I do not want to go in IF.
Zohar Batterywala
zoharsb@gmail.com

 

[martindwilson]

cross posted at excel forum

http://www.excelforum.com/excel-wor...-many-options-actually-4-but-cant-use-if.html