Lookup multiple values return one value corresponding value Excel
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
"DP7" wrote in message
...
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.
|