Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A B C D E F G
1 PRODUCT PRODUCT DATE CODE LOCATION RESULT 2 APPLES AP16063 3 4 5 6 PRODUCT MFG Product Date COLOR LOCATION 7 APPLES TREE AP16057 YELLOW XX001A 8 ORANGE TREE OA16098 ORANGE XX002A 9 APPLES TREE AP16063 RED XX003A 10 CHERRIES TREE CH16075 RED XX004A Formula needs to look up A2 and B2 from data and put the result into E3. I have tried multiple times index/match combo as an array and non-array formula and no luck. Any help would be appreciated. Sorry for the crudeness of a spreadsheet example. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Am Mon, 1 Aug 2016 19:54:25 -0700 (PDT) schrieb Munster: A B C D E F G 1 PRODUCT PRODUCT DATE CODE LOCATION RESULT 2 APPLES AP16063 3 4 5 6 PRODUCT MFG Product Date COLOR LOCATION 7 APPLES TREE AP16057 YELLOW XX001A 8 ORANGE TREE OA16098 ORANGE XX002A 9 APPLES TREE AP16063 RED XX003A 10 CHERRIES TREE CH16075 RED XX004A Formula needs to look up A2 and B2 from data and put the result into E3. what do you want to do? What is the expected result? Count of items? Regards Claus B. -- Windows10 Office 2016 |
#3
![]() |
|||
|
|||
![]()
_§_______________________________________________ _§_ §§______________________________________________ __§§ §§______________________________________________ __§§ _§§_____________________________________________ §§__ ___§§§_______________________________________§ §§____ _____§§§§_______________§§§§§§__________ ___§§§§_____ ______§§§§§§§_________§§§§§§§§§§_ _______§§§§§§______ _________§§§§§§§_____§§§§§§§§§§§ ___§§§§§§§§§________ ___________§§§§§§§§§§§§§§§§§§§ §§§§§§§§§§§___________ _______________§§§§§§§§§§§§§§§§§ §§§§§§§§____________ ________________§§§§§§222222222§§§§§§_ ______________ ________________§§§§§§§§§§§§§§§§§ §§§§_______________ ________________§§§§§§§§§§§§§§§§§ §§§§_______________ _______________§§§§§§§§§§§§§§§§§ §§§§§§______________ _______________§§§§§§§§§§§§§§§§§ §§§§§§______________ _______________§§§§§§§§§§§§§§§§§ §§§§§§§_____________ ______________§§§§§§§§§§§§§§§§§§ §§§§§§§_____________ ______________§§§§§§§§§§§§§§§§§§ §§§§§§§§____________ ______________§§§§__§§§§§§§§§§§§§ ___§§______________ ____________________§§§§§§§§§§§§§____ _______________ ____________________§§§§§§§§§§§§§____ _______________ ____________________§§§§§§§§§§§§______ ______________ _____________________§§§§§§§§§§§_______ _____________ _____________________§§§§§§§§§§§_______ _____________ ______________________§§§§§§§§§__________ ___________ ______________________§§§§§§§§____________ __________ _______________________§§§§§§§_____________ _________ _______________________§§§§§§_______________ ________ _______________________§§§§§§_______________ ________ ______________________§§§§§§§§____________ __________ ______________________§§§§§§§§____________ __________ _____________________§§§§§§§§§§_________ ____________ ____________________§§§§§§§§§§§________ _____________ ___________________§§§§§§_§§§§§§______ ______________ ___________________§§§§_____§§§§__________ __________ __________________§§§§§§___§§§§§§_____ ______________
|
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need the result be the location of APPLES AP16063
|
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Am Tue, 2 Aug 2016 05:50:44 -0700 (PDT) schrieb Munster: I need the result be the location of APPLES AP16063 if the Product Date is a unique value try: =INDEX(E7:E1000,MATCH(B2,C7:C1000,0)) Else try: =INDEX(E7:E1000,MATCH(A2&B2,A7:A1000&C7:C1000,0)) The last formula is an array formula to be entered with CTRL+Shift+Enter. Regards Claus B. -- Windows10 Office 2016 |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for your help again! The array formula worked.
|
#7
![]() |
|||
|
|||
![]()
_________@@@@@@@@_____ _____@@@@@@____________ ___@@@@@@______________ __@@@@@@@_____________ ___@@@@@@______________ _____@@@@@@____________ _________@@@@@@@@_____ ___________________________ ______@@@@@@@@@_______ __@@@@@_______@@@@@__ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ __@@@@@_______@@@@@__ ______@@@@@@@@@_______ ___________________________ ______@@@@@@@@@_______ __@@@@@_______@@@@@__ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ __@@@@@_______@@@@@__ ______@@@@@@@@@_______ ________________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@@@@@@@@@___ __@@@@@@@@@@@@@@___ __@@@@@@@@@@@@@@___.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result | Excel Worksheet Functions | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |