Have look at trailing links

VLOOKUP with multiple criteria. - Microsoft Community

VLOOKUP - Multiple Criteria