Returning a text result from 2 lookup columns

S

sam

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
 
T

Toppers

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

if so:

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

David Biddulph

=IF(AND(A1="Medium",B1="High"),"MH","output undefined") might be one option.
=LEFT(A1)&LEFT(B1) might be an alternative approach.
You'll have to define what output you want for which inputs.
 
B

Bernard Liengme

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
 
Top