I am still completely lost with this VB code stuff, however, i am starting to understand it a little... I think. What I need is for the code below to be able to look at a single cell, and then preform a sort of lookup function on a range of columns. The lookup column would be to the first columns, once it matches it, it would attach all the files from that row, in each column. One might have 1 file associated with it, while another may have 4 files associated with it. 

Please Login or Register  to view this content.
I think the code below is what needs to be changed, but I am not sure how to do it. I think I probably could do it with some sort of formula. 

Please Login or Register  to view this content.
Can anyone help to at least push me in the right direction?

Thanks