X Y Z
Apple Red Company1
Apple White Company2
Apple Blue Company3
Apple Green Company4
Apple Yellow Company5
pear Red Company1
pear White Company2
Pear Blue Company3

The actule table has 50 rows. I would like to type in a value for x and a
value for y and have the macro look up the x value, find the corresponding y
value and return the z value.

user input:
x= Apple
Y= Green

Output
z = Company4

"JNW" wrote:

How many different values are possible for X and Y?
--
JNW


"Elceller in distress" wrote:

I am sorry, I was not clear. I would like to type in a value for x and a
value for Y. I would like the program to determine z. If I type in 1 for x
and 0 for y, it should return the text case3.

Thanks for your help.

"JNW" wrote:

Sumproduct is probably what you are looking for.
--
JNW


"Elceller in distress" wrote:

X | Y | Z
0 | 0 | Case 1
0 | 1 | Case 2
1 | 0 | Case 3
1 | 1 | Case 4

I would like to use a vlookup statement that will allow me to lookup the
values in x and y and return the value of z.

Thanks for your help.