Forum Discussion
nickie115
Oct 25, 2021Copper Contributor
match and equals in seperate sheets
Hello,
I have 2 sheets.
In the main sheet I have a column with ordernumbers and one blanc column that i want the invoice number in.
In the other sheet I have the ordernumber and in the next column I have the invoice number.
So I want the blanc column(invoice number column) in the main sheet, to be filled with the invoicenumbers that equals to the ordernumbers thats next to it. Is this possible??
5 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
nickie115 If you have only one invoice number per order in the "other sheet" you can use VLOOKUP or XLOOKUP (if your Excel version supports it. If, on the other hand, you have multiple invoice numbers for the same order, you'll need something more sophisticated.
- nickie115Copper ContributorI have one invoice number per order but i have multiple orders in the main sheet. I'm kind of lost what columns i should mark as what if I use VLOOKUP or XLOOKUP
- Riny_van_EekelenPlatinum Contributor