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...
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])
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.