Are the results always the first letter of each of A & B

if so:

=LEFT(A1,1)& LEFT(B1,1)

"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