Forum Discussion
PLEASE HELP! How to combine two tables using multiple common values. Not opposed to VBA or formulas.
I have two tables. One table has a value in column A that is duplicated, and in column B there is a somewhat unique identifier. In the second table there is one value for column A that matches the fi...
Let's say the second table is on Sheet 2.
In C1 on the first sheet, enter the formula
=IFERROR(INDEX('Sheet 2'!$C$1:$C$2,MATCH(1,('Sheet 2'!$A$1:$A$2=A1)*('Sheet 2'!$B$1:$B$2=B1),0)),"")
Adjust the sheet name and the ranges, then confirm the formula with Ctrl+Shift+Enter to make it an array formula.
Fill down.
You are amazing HansVogelaar! Thank you so much!