This is the data I have in G1:J4 (I did not want to have to scroll all the
way to MN to experiment)
data a b c
x 1 4 7
y 2 5 8
z 3 6 9


In A1 I have the text: y and in B1 the text: b
IN C1 this formula =VLOOKUP(A1,G2:J4,MATCH(B1,G1:J1,0),FALSE)
returns the value 5
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sam" wrote in message
...
Hi,

I'm trying to return a text result based upon a lookup of two columns. For
example, if column A = Medium, Column B = High, I'd like to be able to
return
a result in a third column of MH. How can I go about doing this.

Thanks as always,
Sam