title: VLOOKUP and MATCH function to extract data from a table in excel. Can I use the same function across multiple cells?
body: <p>could anyone please tell me if they see something wrong with this code? I've been staring at it for hours and I still can't see anything wrong with it but I can't drag it across the cells or even reword it to work for the others it is only working for the first column(Yr3).Any help at all with getting my head around this would be sooo much appreciated!</p>
  
  <pre><code>=IF($B$26="Thousands",VLOOKUP($B29,Assumptions!$C$4:$K$23,MATCH(C$26,Assumptions!$C$4:$K$4),FALSE)/K,VLOOKUP($B29,Assumptions!$C$4:$K$23,MATCH(C$26,Assumptions!$C$4:$K$4),FALSE)/M)
  </code></pre>
  
  <p>This is the part where I am trying to extract the data from</p>
  
  <p><a href="https://i.stack.imgur.com/SNA6a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SNA6a.png" alt="["></a></p>
  
  <p>This is the code I am using</p>
  
  <p><a href="https://i.stack.imgur.com/sPjR8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sPjR8.png" alt=""></a></p>
  
  <p>And this is where I want to PUT the information. The highlighted cell is the one that seems to work but doesn't work going across at all which is my problem</p>
  
  <p><a href="https://i.stack.imgur.com/D2TSe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D2TSe.png" alt="["></a></p>