• 412K Members
• 4,106 Online
• 468K Conversations

Match different dimensions

Occasional Visitor

Match different dimensions

Hello everyone,

I'm having trouble to merge two excel sheets on Year and Country base. attached please see the excel file. On the first sheet, I would like to fill column D with the corresponding (both year and country code base) "Total Eng" data from the second sheet. Could someone please help me to write a formula to merge these data? I would appreciate that..

thank you very much.

Nelind

2 Replies

Re: Match different dimensions

Hi Nelind,

That could be

`=IFERROR(INDEX(Sheet2!\$D\$2:\$D\$56,MATCH(1,INDEX((Sheet2!\$B\$2:\$B\$56=\$A2)*(Sheet2!\$C\$2:\$C\$56=\$B2),0),0)),"no such")`

Re: Match different dimensions

A straightforward formula in D2, copied down rows, is:
=IFERROR(LOOKUP(PI(),
1/((Sheet2!B\$2:B\$56=A2)*(Sheet2!C\$2:C\$56=B2)),
Sheet2!D\$2:D\$56),
0)
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies