Setting Image field from another sheet based on filter/rule


I would like to set a field value with an image from another sheet. Example is I have the following:
Image Sheet

  • NumberA (values 1 to 10)
  • ImageA (various images uploaded)

Calc Sheet

  • NumberB which is a dynamic calculated value 1 to 10
  • ImageB (change this image to match the record image from Image Sheet above)

Simply when NumberA changes to for example 1, then I need to update ImageB with ImageB.

I had a link and load where you select NumberA into NumberB and it brings through ImageA into ImageB but the “Link & Load Sync” fucntion is disabled due to the image.


Can anyone help with this please, I need to get this working for a client?