Lookup multiple values return one value corresponding value Excel

[Guest]

I want to look up multiple values, to return only one value. So far I have
only seen that I can use one lookup value in VLOOKUP. Is there any way or any
other function I should use to look up multiple values to return only one
value? The multiple lookup values I want to use are all in the same row. The
value to be returned is also in that same row.

 

[Biff]

Try one of these: For TEXT

...........A............B............C
1........A............F...........text1
2........C............B...........text2
3........F............G...........text3
4........R............T...........text4
5........X............Y..........text5

Lookup values:

A10 = C
A11 = B

Formula entered as an array using the key combination of CTRL,SHIFT,ENTER
(not just ENTER):

=INDEX(C1:C5,MATCH(1,(A1:A5=A10)*(B1:B5=A11),0))

For numbers (assumes that there is only one instance of corresponding lookup
values):

...........A.............B............C
1........A............F........... 10
2........C............B........... 56
3........F............G........... 77
4........R............T........... 80
5........X............Y.......... 21

A10 = C
A11 = B

Formula normally entered:

=SUMPRODUCT(--(A1:A5=A10),--(B1:B5=A11),C1:C5)

Biff