Sam,

In C1 try:-

=IF(AND(A1="Medium",B1="High"),"MH","")

Mike

"sam" wrote:

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