Forum Discussion

Brass Contributor

Oct 06, 2021

Solved

Multiple criteria

Hello, I have attached a "Trial" file with Input, Data and Output worksheets. In the yellow area, I want to have filled same as Output file but with formulas. The formula should be provide result...

Trial.xlsx14 KB

excel

Formulas and Functions

SergeiBaklan

Oct 06, 2021

Dharmendra_Bharwad

That could be

=IFERROR(
   INDEX(Data!$A$2:$A$5,MATCH($B2,Data!$G$2:$G$5,0)),
 IFERROR(
   INDEX(Data!$A$2:$A$5,MATCH($C2,Data!$B$2:$B$5,0)),
 IFERROR(
   INDEX(Data!$A$2:$A$5,MATCH($D2,Data!$D$2:$D$5,0)),""))
)

for Company ID, other fields are similar.

Trial (1).xlsx15 KB

Yea_So

Bronze Contributor

Oct 06, 2021

Please indicate which excel version you have so the formulas used in the solution can be maximized to its full potential/ease.

cheers