VLOOKUP Images?

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

Private Sub Worksheet_Calculate()
    
    Dim myShape As Shape
    Dim r As Range
    Dim mySh As Worksheet
    
    Application.EnableEvents = False
    Application.ScreenUpdating = False
    
    On Error Resume Next
    For Each myShape In Me.Shapes
        If myShape.Name Like "*ID" Then myShape.Delete
    Next myShape
    On Error GoTo 0
    
    Me.Shapes(Replace(Range("B7").Value, " ", "")).Copy
    Range("B7").Select
    Me.Paste
    Selection.Name = Replace(Range("B7").Value, " ", "") & "ID"
    Application.EnableEvents = True
    Application.ScreenUpdating = True
    
End Sub

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.

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

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

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.