I have created a file were i need to insert a picture for different codes,

example code 1 for picture 1

in my data base sheet i select the code and picture should appear in the next cell were i give reference.

The same action i wan to do it in different cells for all the cases i need to get same list and selected should appear in different cell.

Like if i select in a1 the picture should appear in b1 if i select the code in a2 the picture appear in b2
selection of picture.png

in this image when we select the picture code is appeared in the cell, i want the picture to appear in next cell and also the code in another cell