VLOOKUP with merged cells as the lookup_value

I am trying to use the value in column D (merged cell) and pull all values from Column J (non merged cells) into another sheet within the spreadsheet. I have tried using the vlookup formula but I only get the first associated value from column J instead of all of them (there can be anywhere from 1 -8 values in column J). I do not know how to get this data transferred over correctly.

Don't use merged cells, try this instead https://www.businessmanagementdaily....nter-in-excel/

Merged cells - the work of Satan!! You should NEVER use them.

A picture is worth 1000 words, a sample sheet is worth 1000 pictures!!

You have attached a non-editable picture of an Excel sheet. That's not very easy to work with. Also... I'm lazy. I have to re-type your information before I can begin to address your problem. That puts me off completely.

So.... Do yourself a favour and please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough). However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever).

Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Make sure confidential information is removed first!!!!

Glenn,
I attached a spreadsheet of a sample of data. Basically when the SKU in column D of the sales sheet, I want it to pull the all
EP product ID's from the EP Bundle list sheet from the same SKU that is associated in D of that same page. The original file for
the EP Bundle List is 8,000 lines long and has the SKU in column D listed several times but the results in column J are the same
for each time it is listed. The sample of data on the Sales sheet is just a few items that we sold in one month. I need to do
this for an entire year. But If I can get the right formula then it should be no problem. I just don't know what that is yet.

There are probably more complicated formulas that will do what you want however I suggest the use of two helper columns which may be moved and/or hidden for aesthetic purposes.
One helper column is in column K of the EP Bundle list sheet and is populated using: =IF(ISTEXT(D2),D2,K1)
The other helper column is in column F of the Sales sheet and is populated using: =IF(ISTEXT(D2),D2,F1)
Column E on the Sales sheet is populated using: =INDEX('EP Bundle List'!J$2:J$19,AGGREGATE(15,6,(ROW(J$2:J$19)-ROW(J$1))/('EP Bundle List'!$K$2:$K$19=F2),COUNTIFS(F$2:F2,F2)))
Note that since you said the SKU's are listed several times, I suggest that you use a pivot table as modeled on the PT sheet.
Let us know if you have any questions.