Need help with OFFSET for 2 reference

[Akbaruu]

Hello, on my Data Validation list I use formula =OFFSET(PicTable,,,,1) is there anyways to make 2 offsets? like =OFFSET(PicTable,,,,1,PicTable,,,,2,PicTable,,,,3) ?

Please help

[AliGW]

Please provide an example workbook showing what you want and what you expect the outcome to be.

[Akbaruu]

Hey, I have a VBA code wich call specific photo when I choose from Data Validation list, let's say I I choose from list Apple it shows apple , but I want it to show 4 photos instead of 1.

[FDibbins]

As suggested by Ali, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.