Vlookup to show different sub categories in the same category

[Guitarist]

Good afternoon!

I had a question on to write the vlookup formula for the below issue.

Show sheet 2 column 4 in sheet 1 column 4. I appreciate the help! Please see attached.

[sandy666]

with Power Query

Column 1	Column 2	Column 3	Column 4
1	Smith, John	Type	Business 1
1	Smith, John	Type	Business 2
1	Smith, John	Type	Business 3
1	Smith, John	Type	Business 4
1	Smith, John	Type	Business 5
1	Smith, John	Type	Business 6

Please Login or Register  to view this content.

[azumi]

Put in D2 then copied down

=IFERROR(INDEX(Sheet2!$D$2:$D$8,AGGREGATE(15,6,(ROW(Sheet2!$D$2:$D$8)-MIN(ROW(Sheet2!$D$2:$D$8))+1)/(Sheet2!$B$2:$B$8=$B2),COUNTIF($B$2:B2,B2))),"")

[Guitarist]

Thank you all! Have a great day!!

[sandy666]

You are welcome

---

if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)