software

I am trying to set up the formula for lookup using the assist where I can
fill in the function arguments:

In lookup value, I enter B2 and the correct value is displayed.
In lookup vector, I enter something like quot;Aquot;,quot;Bquot; - the value displayed is
INVALID
In the result vector, I want 1 to display if A is matched and 2 to display
if B is matched. I have entered 1,2 and it shows as quot;1,2quot;

What am I doing wrong here?

Thanks,
Barb Reinhardt=LOOKUP(B2,{quot;Aquot;,quot;Bquot;},{1,2})

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Barb Reinhardtquot; gt; wrote in message
...
gt; I am trying to set up the formula for lookup using the assist where I can
gt; fill in the function arguments:
gt;
gt; In lookup value, I enter B2 and the correct value is displayed.
gt; In lookup vector, I enter something like quot;Aquot;,quot;Bquot; - the value displayed is
gt; INVALID
gt; In the result vector, I want 1 to display if A is matched and 2 to display
gt; if B is matched. I have entered 1,2 and it shows as quot;1,2quot;
gt;
gt; What am I doing wrong here?
gt;
gt; Thanks,
gt; Barb Reinhardt
gt;
gt;
gt;
gt;