0

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

Improve this question
0

1 Answer 1

Reset to default
1

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

=INDEX(IFERROR(VLOOKUP((A3:A&B1),{Sheet2!A3:A&Sheet2!B3:B,Sheet2!C3:C},2,0)))

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

Improve this answer
2
  • Wow, marvellous, thank you very much! Great help!
    – Kőhegyi Atilla
    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.
    – marikamitsos
    Jul 20, 2022 at 8:47

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