Forum Discussion

optinlists15's avatar
optinlists15
Copper Contributor
May 03, 2018

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...
Formulas & Functions
Need Help
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 03, 2018

Robin-

 

Not exactly sure how your data is set up, but maybe something like this will work (See attached Excel File for further reference):

 

=IFERROR(INDEX('Sheet with Order & Address'!$A$2:$B$13,MATCH(A2,'Sheet with Order & Address'!$A$2:$A$13,0),2),"Order Not Present")

 

optinlists15's avatar
optinlists15
Copper Contributor
May 04, 2018

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!

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 04, 2018

    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.

Resources