title: Using dynamic arrays and offset based on certain criteria
body: <p>Currently, I am trying to obtain values from a different excel workbook (workbook b) for use in my current excel workbook (workbook a).</p>
  
  <p>Here are the workbooks in question:</p>
  
  <p><strong><em>Workbook a:</em></strong> <br>
  <a href="https://i.stack.imgur.com/Vpts8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Vpts8.png" alt="enter image description here"></a></p>
  
  <p><strong><em>Workbook b:</em></strong><br>
  <a href="https://i.stack.imgur.com/DLO8Y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DLO8Y.png" alt="enter image description here"></a></p>
  
  <p>I'm trying to automatically fill in 'Output' by using index match with Output and the Unique ID which is present in both workbooks. However, a 0 will be returned  where there is no value in the numbering field. I want excel to search in this way (<a href="https://i.imgur.com/Gpsz1vR.png" rel="nofollow noreferrer">https://i.imgur.com/Gpsz1vR.png</a>), where the search would start from the Unique ID number leftwards 2 columns and continue upwards until it finds a value. However, I've tried some combinations of offset and IF, but I haven't succeeded yet. I would be grateful if anyone could point me in the right direction. Thanks!</p>
  
  <p>*I should add that I am very new to excel and have only really learned what I know now through web searches.</p>