Forum Discussion
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...
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.
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.
Thanks for working out the formula. However, the formula reverts the same result for Company id and other fields. It is not dynamic. Can you please re-work on this?