Hi there,
I am trying to figure out how to perform a VLOOKUP and return a concatenated result from multiple columns on the matched row. Below is how I want the data to end up looking:
Result Worksheet
<tbody>
</tbody>
Database Worksheet
<tbody>
</tbody>
The VLOOKUP for the single match in the "Phone" column is working fine.
Example for B2 in "Result" Worksheet:
Now for cell C2 in the "Result" worksheet I want to concatenate C2:E2 in the "Database" worksheet (adding commas and spaces in between). Can someone please advise? Thanks a million!
Jared
I am trying to figure out how to perform a VLOOKUP and return a concatenated result from multiple columns on the matched row. Below is how I want the data to end up looking:
Result Worksheet
A | B | C | |
1 | Full Name | Phone | Address |
2 | Joe Smith | 1234 | 123 Gumdrop Lane, Gummie, Candyland |
3 | Sally May | 5678 | 123 Snickers St., Cocoa, Candyland |
<tbody>
</tbody>
Database Worksheet
A | B | C | D | E | |
1 | Full Name | Phone | Home Street | Home City | Home State |
2 | Joe Smith | 1234 | 123 Gumdrop Lane | Gummie | Candyland |
3 | Sally May | 5678 | 123 Snickers St. | Cocoa | Candyland |
<tbody>
</tbody>
The VLOOKUP for the single match in the "Phone" column is working fine.
Example for B2 in "Result" Worksheet:
Code:
=IF(A2<>"",VLOOKUP(A2,'Database'!$A$2:$E$3,2,FALSE),"")
Now for cell C2 in the "Result" worksheet I want to concatenate C2:E2 in the "Database" worksheet (adding commas and spaces in between). Can someone please advise? Thanks a million!
Jared