title: #VALUE! align cell position missing (excel)
body: <p>I use this formula to align cells like here </p>
  
  <p><a href="https://i.stack.imgur.com/E7BiX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E7BiX.png" alt="enter image description here"></a>
  <br>I put this formula in <strong>E3</strong> and then I press CTRL+SHIFT+ENTER</p>
  
  <pre><code>=INDEX($D$3:$D$6,MATCH("*" &amp; MID(B3,SEARCH("http",B3),99),$D$3:$D$6,0))
  </code></pre>
  
  <p>The formula stops at the first step, but does not consider that the function that values do not align correctly, that is what I seek. 
  if I change position of cells of column D formula return me this error:</p>
  
  <pre><code>#VALUE! 
  </code></pre>
  
  <p>Look this pic, please: </p>
  
  <p><a href="https://i.stack.imgur.com/bdK5k.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bdK5k.png" alt="enter image description here"></a></p>
  
  <p>Is there any solution to correct position of cells of <strong>column E</strong> with column D <strong>after</strong> first formula alignment between B-D?</p>
  
  <p><strong>Note</strong>: alignment must following same LINK and It should value the same function as a loop. Loop because function must look at the alignment with the neighboring column, in our case is the D until e.g <code>http://beta.com</code> link is on the same row level. They could take more steps, but eventually you have to get to an array. P.S: each link of start column (B) is unique</p>