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.
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.