Multiple criteria

[Dharmendra_Bharwad]

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

[#2 · Accepted solution]

@Dharmendra_Bharwad 

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.

[#3]

@Sergei Baklan 

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?

[#4]

@Dharmendra_Bharwad 

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.

[#5]

Please indicate which excel version you have so the formulas used in the solution can be maximized to its full potential/ease.

cheers

[#6]

@Sergei Baklan 

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.

[#7]

I have resolved this on my own. Thanks for the help. However, I will mark this as best response.

[#8]

@Dharmendra_Bharwad 

Thank you for the feedback. You need to change the references, not just copy/paste.