VBA to insert Vlookup to a range of cells

[Biplab1985]

Hi Experts,

I am trying to insert vlookup to return a range of cells in destination sheet when 4 criteria are met.

I have merged all the referenced criteria in source sheet in Column A for easier lookup. I tried this code but could not finish

Please Login or Register  to view this content.

[mjr veverka]

Maybe this way?:

Please Login or Register  to view this content.

[Biplab1985]

Can someone help me here, I tried this code but what happens is it produce result vertically and not horizontally. Apple, After that below Carrot and then under pineapple for Q1. Can anyone help me out here. Counting on you guys, i am almost there. only this little help needed

Please Login or Register  to view this content.