Hello,
I have two sheets. One sheet has three Columns of data (A, B, C), the other sheet has two Columns of data (A,B) and the third column (C) is empty. I need to match (Columns, A & B) from Sheet 1 to Sheet 2 and whatever matches, put that data from Sheet 2 "C" column into Sheet's 1 "C" Column.
Here is my code so far, It matches the "A" column and puts the data into the "C" column:
=IFERROR(INDEX(Sheet2!C:C,MATCH(A1,Sheet2!A:A,0)),"")
I have been trying to edit the code to add the additional code to match the "B" column. Can anyone tell me what I need to do? Thank you in advance for any help::
Bookmarks