I have a list of invoice numbers in a column. In another sheet I have the same invoice numbers but with items in another column and a third with sold numbers.
I'd like to get this sales data in the first sheet as a stock management. I tried it with double vlookup and iferror but cannot solve the problem.

Sample: https://docs.google.com/spreadsheets/d/1ilGQG5umhHXY483vEiQX2esHCulLytK4uIXfAgNkU8E/edit?usp=sharing


1 Answer 1


You can use a single VLOOKUP (in each of B3, E3, H3 etc)


The formulas work by creating 2 "helper columns" like A3:A&B1 and Sheet2!A3:A&Sheet2!B3:B.
We also change cell B1 to E1, H1 etc.

(Do adjust the formulae according to your ranges and locale)

enter image description here

  • Wow, marvellous, thank you very much! Great help! Jul 20, 2022 at 7:47
  • Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. You can even upvote the answer. If you don't have enough reputation, your upvote will show up later, once you reach enough reputation points. Jul 20, 2022 at 8:47

Not the answer you're looking for? Browse other questions tagged or ask your own question.