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.
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.
Thank you for the feedback. You need to change the references, not just copy/paste.