software

I would like to know how I can take multiple cells together in a VLOOKUP
formula. Let me explain, I have 2 sheets:

Sheet1
A
1 Red
2 Blue
3 Yellow
4
5 =VLOOKUP(A1amp;A2amp;A3, Sheet2!A15,4) answer 15Sheet2
A B C D
1 Red Blue Yellow 10
2 Orange Purple Black 20
3 Pink White Silver 15
4
5

I want the VLOOKUP to return the value 10 from Sheet2, but it returns 15.
apparently the Vlookup cannot handle multiple Vlookup values.

Is there a way to solve this?

Your help is highly appreciated!

RMF


=INDEX(D15,MATCH(A1amp;A2amp;A3,A1:A5amp;B1:B5amp;C1:C5,0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;RMFquot; gt; wrote in message
...
gt; I would like to know how I can take multiple cells together in a VLOOKUP
gt; formula. Let me explain, I have 2 sheets:
gt;
gt; Sheet1
gt; A
gt; 1 Red
gt; 2 Blue
gt; 3 Yellow
gt; 4
gt; 5 =VLOOKUP(A1amp;A2amp;A3, Sheet2!A15,4) answer 15
gt;
gt;
gt; Sheet2
gt; A B C D
gt; 1 Red Blue Yellow 10
gt; 2 Orange Purple Black 20
gt; 3 Pink White Silver 15
gt; 4
gt; 5
gt;
gt; I want the VLOOKUP to return the value 10 from Sheet2, but it returns 15.
gt; apparently the Vlookup cannot handle multiple Vlookup values.
gt;
gt; Is there a way to solve this?
gt;
gt; Your help is highly appreciated!
gt;
gt; RMF