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.