Forum Discussion
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 col...
I 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
nickie115 Perhaps the attached file will help,
- Thank you but what do you write after vlookup?
What is our search key? is it our invoicenumber or ordernumber?
Which range is it? Is it the invoice number/ordernumber?
What is the index and how is it sorted?
VLOOKUP(search_key, range, index, [is_sorted])nickie115 Have you looked at the formulae in my example? Google for VLOOKUP and/or XLOOKUP. There are many tutorials on line. Better at explaining than what I can write up here in a few minutes.