Help with either INDEX or VLook return for multiple values horizontally

[dmxcasper2]

Description of problem: I need help with utilizing V-Look like function to match values between 2 sheets and pull multiple values and report them horizontally.

Data to pull from sheet "All Items Pivot".
Trying to match vlues from Column B.

Data to compare from sheet "JK Item listing".
Trying to match values from Column A.

The matching values will need to pull into sheet "KJ Item Listing" into Column E for values occuring only once. For values occuirng twice to pull into Column E and F. Etc.

Any help is appreciated.

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

So assuming that you have Excel 365 with the FILTER function, then in E2 of 'JK Item Listing' & copy down (results should automatically 'spill' to the right)

=TRANSPOSE(FILTER('All Items Pivot'!D$4:D$1000,'All Items Pivot'!B$4:B$1000=A2,""))

For the future also best if you give your sample data and results with XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. And keep your sample data small so that helpers can see the connection between your data and results. In your image we cannot see any of the data from col A of 'JK Item Listing' in col B of 'All Items Pivot'.

 

[Peter_SSs]

So assuming that you have Excel 365 with the FILTER function

If that is not the case, then try this in E2 of 'JK Item Listing' & copy across and down

=IFERROR(INDEX('All Items Pivot'!$D:$D,AGGREGATE(15,6,ROW('All Items Pivot'!$B$4:$B$1000)/('All Items Pivot'!$B$4:$B$1000=$A2),COLUMNS($E:E))),"")