lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
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>