Forum Discussion
Data Matching and Merging
Hello, I have two worksheets that have one common denominator (which is order #). I want to tell Excel that if the order numbers match on both worksheets, then add the email address from one workshe...
Thanks Matt! I actually figured it out and used the formula:
=vlookup(B31:sheet1!$B$2:C$733,2,FALSE)
Moved all of the email addresses over to the other sheet by matching the order numbers.
It has been a while since I have done this process, so thanks for the help!
Glad you were able to get your issue resolved! Vlookup() is a very useful function. Sometimes, if data structure can't be modified you can use Index() Match() which is essentially the same thing. The difference is that Vlookup() can only look to the right, while an Index() Match() can look left or right. There are also other performance implications based on which one you use which only really come into play for extremely large workbooks.