I've seen several posts for multi-condition vlookups when data is in
sequential columns but it wasn't clear how to accomplish the same thing when
you need to index a column not adjacent to the columns you are testing. For
example using the following:

Year Model Company a b c e
2005 Red a 10
2005 Green b 100
2004 Green c 50
2005 Red a 20
2002 Yellow a 10

How would you right a vlookup that only searched for 2005, Red, Company A
and returned 20 from colum e?

Thanks in advance.