Excel 2007 : formulae to evaluate one from four options

[ZOHAR]

Respected ,
Its easier to make the formula for evaluating one of 3 options but I want to select one out of four options
eg
O H L C (open-high low close)

1 5 2 4 here can be oh (or can be any 4th option)
2 5 1 4 here ol (or can be any 4th option)
4 5 1 2 here lc works (or can be any 4th option)
This can be selected using if (loop)(if , (elseif, else))
but
The problem is here
hc (or can be any 4th option)
3 7 4 6

Please even if it is made not using if , I will try to accomodate
THANX in ADVANCE
Zohar Batterywala
[email protected]

[NBVC]

You'll have to try again... more clearly... I, for one, don't understand a thing from the above description.