Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup multiple values return one value corresponding value Excel
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BIFF - Help!! lookup numbers in multiple columns and return one nu | Excel Worksheet Functions | |||
lookup mutliple values to return one value | Excel Worksheet Functions | |||
lookup serch term and return sum of all values | Excel Worksheet Functions | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |