Home

Match 2 columns in sheets and return a 3rd column

GailY10
Occasional Visitor

I have sheet 1 with January sales in sheet 1 and I want to add February sales from sheet 2 for the same customer/item combination. 

In sheet 1 I want to match column a and column b in a row with the same columns in sheet 2 and return column c of sheet 2 to column d in sheet 1. example attached

1 Reply

@GailY10 , that could be

=IFERROR(INDEX(Sheet2!$C$2:$C$10,MATCH(1,INDEX((Sheet2!$A$2:$A$10=A2)*(Sheet2!$B$2:$B$10=B2),0),0)),0)

as in attached file

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies