VLOOKUP Images?

[dwd_uk]

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?

[Bernie Deitrick]

You could use the worksheet's calculate event. With your formula above in, say, cell B7 and with pictures on the same sheet named

FirstNameLastName

where the formula will return FirstName LastName

1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed

Please Login or Register  to view this content.

[dwd_uk]

Thanks, but unfortunately I think this is a little beyond my skillset!

If someone could help I can forward them a download link...

Could somehow show me how to make this work?

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

[dwd_uk]

Attachment 652909
Attachment 652910

Images attached.

So I am trying to get the images in E2 and F2 from the second sheet to populate the first sheet when I select the user?

I have created a table in the second sheet called TABLE2

[Pepe Le Mokko]

Again, please read CAREFULLY the yellow banner, to attach a sheet not a useless picture !

[Glenn Kennedy]

Please re-read Post 4. A picture of a sheet is non-editable. I asked for a small sample SHEET.

[dwd_uk]

Please find attached

[Bernie Deitrick]

This works for Joe Bloggs and Alan Bradley - note how their pictures are named on the Staff sheet.

My advice: use very small, compressed pictures or this will become slow.