Match and Display? Is it possible

[LazyBoy121]

Hi all,

Wondering if anyone can help me, I attached a sample excel workbook to show exactly what I am trying to do.

I need to search/match names on the jobs sheet and display the description in the row next to that name on the corresponding P.O. sheet, is this possible?(example in workbook is John Good)

I have tried VLookUp and IF functions, they work well but only to display the first match and I need to display multiple results.

If need be I can enter the name and description in the same cell but would prefer not to.

I have little VB writing skills so if what I am after is obtainable through common functions that would be great.

Thanks in advance for any help.

Edit*Sorry Forgot Attachment*Edit

[davesexcel]

No Sample provided

[JBeaucaire]

I always solve little things like that with an INDEX. On the "jobs" sheet, I told the index column I added to Column A to increment only once when the Name in column B matches the Name on the Summary sheet.

Then a Formula on the Summary sheet gathers the lines that increment. Have a look.