title: Use Vlookup across multiple sheets in Google sheets
body: <p>I am using Vlookup formula to lookup data in V5 sheet of another google sheet, and it works perfectly. There is another tab named V7 in same google sheet which has similar data but column alignment is different. I want my vlookup function to lookup in the V7 tab as well.</p>
  
  <pre><code>=ARRAYFORMULA(If(A2:A="","",VLOOKUP(A2:A, {IMPORTRANGE("1MNRMKGkC-c0COugUWpXOe5OxJXfmdXGboxAPhf5SaLA", "V5!T3:T"), IMPORTRANGE("1MNRMKGkC-c0COugUWpXOe5OxJXfmdXGboxAPhf5SaLA", "V5!D3:D")} ,2,0)))
  </code></pre>
  
  <p>This is my current formula, can I somehow modify the formula to include V7 tab as well, assume the column ordering of V7 to be the same as V5. I can modify that later.</p>
  
  <p>Thanks a lot in advance</p>