Rahul asks:

i want to know that when we create a vlookup sheet, and in the name column we enter a name and excel shows all details and a photo.

Answer:

changepicture

Formula in cell C4:

=INDEX(Data!B2:B9,MATCH(C2,Data!A2:A9,0))

Formula in cell C6:

=INDEX(Data!C2:C9,MATCH(C2,Data!A2:A9,0))

I have hidden the contents in cell C6. Select cell C6. Press Ctrl + 1. Click Custom and type ;;;

VBA code

  1. Right click on sheet name
  2. Click "View Code"
  3. Paste code below to sheet module
  4. Exit VB editor
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$2" Then
    Shapes(1).Delete
    Pictures.Insert(ActiveSheet.Range("C6").Value).Select
    With Selection
        .Height = 120.24
        .Width = 180
        .Left = 96.75
        .Top = 90
    End With
    Range("C3").Select
End If
End Sub

Data sheet

change picture - data sheet

Download *.zip file
Vlookup pictures.zip