displaying names and images randomly..

[genc27]

Hi
Say in sheet1 I have 20 names of students in col A, and their pictures are in col B or better in sheet2
I want to select one of the names and his/her picture randomly to decide who will answer the question.
I can select the name by using "randbetween" but how can I pick both the images and names(using a macro/button)?

[genc27]

Hi
Say in sheet1 I have 20 names of students in col A, and their pictures are in col B or better in sheet2
I want to select one of the names and his/her picture randomly to decide who will answer the question.
I can select the name by using "randbetween" but how can I pick both the images and names(using a macro/button)?

Here is my attached file with some images.