VLOOKUP based on multiple lookup_values?
Posted by david m on January 28, 2002 7:16 PM
Is there a way to do a VLOOKUP that is based on more than one lookup_value or criteria? For example, assume the following on Sheet 1: the value 1 is in cells A1, A2, and A3 a,b, and c are the values in B1, B2, and B3 the value 2 is in cells C1, C2, and C3 xxx, yyy, and zzz are the values in cells D1, D2, and D3. Is there a formula I can put on Sheet 2 that would examine data entry in three different cells on Sheet 2, look for a match in a row on Sheet 1 and return the value from the 4th column (i.e. if I enter 1, B, 2 in three cells could a formula return yyy?).