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?
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.
When I copy and paste the formula, it shows same value in other column
And I need this to be achieved as an output:
Hop this clears.
- I have resolved this on my own. Thanks for the help. However, I will mark this as best response.