vlookup() returning multiple values

[lezawang]

Hi
I want to use vlookup() to return multiple values. User will enter the name in cell G2 and vlookup() will return phone number and address. So I selected 2 cells (I2 and J2) and typed this function

G2=VLOOKUP(G2,A2:C15,{2,3},flase)

and pressed ctrl+shift+enter

But I got error msg #Name . Not sure why? Any help would be very much appreciated.

name	phone#	address
mary1	1	1 main st
mary2	2	2 main st
mary3	3	3 main st
mary4	4	4 main st
mary5	5	5 main st
mary6	6	6 main st
mary7	7	7 main st
mary8	8	8 main st

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Joe4]

VLOOKUP can only return a single value.
You would just write two VLOOKUP formulas, one to return column 2 and one to return column 3.
If you want them both in the same cell, just use CONCATENATE or & to sew them together, i.e.

[COLOR=#333333]=VLOOKUP(G2,A2:C15,2,false) & " " & [/COLOR][COLOR=#333333]VLOOKUP(G2,A2:C15,3,false)[/COLOR]

 

[lezawang]

Very nice idea. Thank you so much.

 

[Joe4]

You are welcome.