Hi all.

I have a query if anyone can help?

I have a list of employees in Sheet2 of my Excel sheet (called Staff). The sheet has 6 columns (Name, NI No, Staff Qualifications, What Staff Can Use, Staff Card FR, Staff Card BK). The first four columns are data, but the final two are images.

On Sheet one, I want to be able to select an employee in column 1, which then populates 2 - 6 with the rest of the data from Sheet2.

I've done this fine with the data columns, but can't find any way to do it with the images?

So for NI No, for example, I have used: =VLOOKUP(A7, Staff!A:G,2,FALSE)

But no idea how to make this work for the images?

Can anyone provide any guidance?