title: How to display an image from another sheet with a reference from current sheet?
body: <p>I have an excel workspace with <code>2</code> sheets, in a similar manner with how they are described in this question:</p>
  
  <p><a href="https://stackoverflow.com/questions/56579974/excel-how-to-reference-a-value-from-another-sheet-with-a-reference-from-curren">Excel - How to reference a value from another sheet with a reference from current sheet</a></p>
  
  <p>How can I display images from <code>sheet2</code> into <code>sheet1</code> using index references from <code>sheet1</code>? One of the comments suggested VBA, however, I am new to this. Some of the cells have missing images, and in this case, I just want to skip them.</p>
  
  <p>Just to be clear, <code>sheet2</code> contains a database of quiz questions, where some of the questions have a corresponding image. In <code>sheet1</code>, I want to select randomly some of the questions from <code>sheet2</code> to form up a quiz. I was able to do this with the text of the question by using the answer from the above link. However, I want to display the corresponding images from <code>sheet2</code> whenever is the case.</p>
  
  <p>Below are some images with my Excel workspace.</p>
  
  <p><a href="https://i.stack.imgur.com/eFRf9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eFRf9.png" alt="enter image description here"></a><a href="https://i.stack.imgur.com/H9HP9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H9HP9.png" alt="enter image description here"></a></p>
  
  <p>I want to display the question <code>154</code> from <code>sheet2</code> onto <code>sheet</code>. I am able to do so with the answer from the above link. However, I cannot display the adjacent image to <code>sheet1</code> as in the bellow image. I tried with the command <code>=INDEX(sheet2!C:C,($A1 - 1)*4 + 1)</code>, but it failed.</p>