Hi there
I can think of no way to link cell text to a jpeg and call it via a formula.
You might however like to try something like this:
Right click each sheet tab in turn, left click View Code to open the VB Editor and paste this in the large code window:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
ActiveSheet.Pictures.Insert( _
"C:\Documents and Settings\DEREK\My Documents\My Pictures\" & Target.Value & ".jpeg" _
).Select
Selection.Left = Target.Left
Selection.Top = Target.Top
End Sub
You will need to change this part of the above code to the pathway to your own jpegs:
C:\Documents and Settings\DEREK\My Documents\My Pictures\
Alt+F11 allows you to exit from the VB Editor. Now when you enter the name of a jpeg in a cell, if it exists, it will be inserted into the worksheet with its top left corner covering the cell.
regards
Derek