it's not working. Any other idea?

"Jacob Skaria" wrote:

Try

=CHOOSE(ROUND(AVERAGE(VLOOKUP(A1,{"high",3;"low",1 ;"medium",2},2,0),
VLOOKUP(B1,{"high",3;"low",1;"medium",2},2,0)),0), "low","medium","high")

--
Jacob


"Postman" wrote:

Hi All

I have question for you. I have letter "h" (from high) in column A1 and
letter "L" (from low) in column B1. In column C1 i would like to get the
avarage from them which is "m" (from Medium). How to do it?

Thanks in advance