I need to look up data from a different worksheet based on two criteria: (Main worksheet)
Company (A1), Fund Name (B1) and Stage (C1)
A | X
A | Y
A | Z
B | I
C | X
C | I
A-C are company names, I, X-Z are fund names and i need stage data
In (worksheet 2) I have the raw data, where the data for company, fund and stage are. I need to import the data for stage into the main worksheet given if company A matches fund X. I tried sumproduct but that doesnt allow non-numerical data
Company (A1), Fund Name (B1) and Stage (C1)
A | X
A | Y
A | Z
B | I
C | X
C | I
A-C are company names, I, X-Z are fund names and i need stage data
In (worksheet 2) I have the raw data, where the data for company, fund and stage are. I need to import the data for stage into the main worksheet given if company A matches fund X. I tried sumproduct but that doesnt allow non-numerical data