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 if one or more condition matches based on company ID (column B) , domain (column D) or Name (column C).
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.
7 Replies
- Please indicate which excel version you have so the formulas used in the solution can be maximized to its full potential/ease.
cheers 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?
Sorry, when I didn't catch what is required.
Here is desired output (Output sheet)
That is what formula returns (Input sheet)
I see no difference.
