vlookup with multiple criteria

[lcornaro]

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

 

[BrightAndAlert]

Not quite sure what the stage data is.
Have you tried adding the Company name (a1) and Fund name (b1) in a string =a1&b1. Do the same in you raw sheet. Then vlookup these...

 

[lcornaro]

stage data is what stage the company is at, ie growth, start-up or seed. I cant add the two because they are already used for a sumproduct function. From what ive read you can use index (match (if)) function, but i havent been able to master it yet..

 

[BrightAndAlert]

If you add them together in a separate column it should not affect your ofther functions...