Oct 06 2021 06:15 AM
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).
Oct 06 2021 06:54 AM
SolutionThat 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.
Oct 06 2021 10:04 AM
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?
Oct 06 2021 12:46 PM
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.
Oct 06 2021 12:49 PM
Oct 07 2021 02:50 AM
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.
Oct 07 2021 05:40 AM
Oct 07 2021 01:22 PM
Thank you for the feedback. You need to change the references, not just copy/paste.
Oct 06 2021 06:54 AM
SolutionThat 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.