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