0
I have two different tabs in excel. Tab1 has three columns (ID1, ID2, and Value). Tab2 has two columns (ID1, ID2), and I'm trying to write a function that will transfer "Value" from Tab1 into the third column of Tab2 if ID1 and ID2 match on both tabs. I've tried writing functions through VLOOKUP and INDEX (given other STACKS Overflow questions/answers), but am having a tough time figuring this one out. All advice would be appreciated!
Tab1 with columns ID1, ID2, and Value
Tab2 with columns ID1, ID2, and Value which I'm hoping to retrieve from Tab 1 if ID1 and ID2 match
Thank you Scott Craner. This worked beautifully with my dataset! Thank you for the link to the other StackOverflow Answer as well. – Stephanie Galla – 2018-02-19T02:21:13.107