Multi Vlookup formula with results in one setting and set out in paragraphs.

Hi,

Ok so im a total noob when it comes to Excel and i have very basic knowledge when it comes to working with Vlookups, i know how to do them etc but im looking to see if i can get a vlooklup to pull several return values and populate them into a merged cell.

So the vlookup i have is as follows

Please Login or Register  to view this content.

I have this formula in Cell A7 but when the formula returns the results it is spilling them over several cells.

What i want to do is have the Vlookup return the results into a set of merged cells and be formatted to read like paragraphs on a page.


Any help you can provide would be appreciated.

Thanks in advance.Mock up.xlsx

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

After looking at your workbook, I am confused by your needs. Use the sample file and explain specifically what you want and how the end result should look. Explain in simple English terms.

Using Power Query

Please Login or Register  to view this content.

OK - so here's the thing: you can get the data into one cell with a formula, but you CANNOT merge cells using a formula. The merging would need to be done manually.

To get the result into one cell (say A8):

=TEXTJOIN(CHAR(10)&CHAR(10),,VLOOKUP(B1:B5,Sheet1!A1:B10,2,FALSE))

NOTE: you will need to set the cell formatting to WRAP TEXT on the Home ribbon.