Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109137 > unrolled thread
| Started by | Munster <hangerjj@gmail.com> |
|---|---|
| First post | 2016-08-01 19:54 -0700 |
| Last post | 2016-08-03 12:27 +0100 |
| Articles | 7 — 4 participants |
Back to article view | Back to microsoft.public.excel.programming
Index and Match Help Munster <hangerjj@gmail.com> - 2016-08-01 19:54 -0700
Re: Index and Match Help Claus Busch <claus_busch@t-online.de> - 2016-08-02 07:08 +0200
Re: Index and Match Help Munster <hangerjj@gmail.com> - 2016-08-02 05:50 -0700
Re: Index and Match Help Claus Busch <claus_busch@t-online.de> - 2016-08-02 14:56 +0200
Re: Index and Match Help Munster <hangerjj@gmail.com> - 2016-08-02 17:31 -0700
Re: Index and Match Help banhtrungthu68 <banhtrungthu68@gmail.com> - 2016-08-02 13:22 +0100
Re: Index and Match Help banhtrungthu247 <banhtrungthu247@gmail.com> - 2016-08-03 12:27 +0100
| From | Munster <hangerjj@gmail.com> |
|---|---|
| Date | 2016-08-01 19:54 -0700 |
| Subject | Index and Match Help |
| Message-ID | <3dbdc2cb-b093-4033-bef7-7a637cd320fe@googlegroups.com> |
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.
[toc] | [next] | [standalone]
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Date | 2016-08-02 07:08 +0200 |
| Message-ID | <nnp9rq$tnd$1@dont-email.me> |
| In reply to | #109137 |
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
[toc] | [prev] | [next] | [standalone]
| From | Munster <hangerjj@gmail.com> |
|---|---|
| Date | 2016-08-02 05:50 -0700 |
| Message-ID | <a3b0cc7b-6076-460c-836f-8da3004392a0@googlegroups.com> |
| In reply to | #109138 |
I need the result be the location of APPLES AP16063
[toc] | [prev] | [next] | [standalone]
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Date | 2016-08-02 14:56 +0200 |
| Message-ID | <nnq5ap$bsi$1@dont-email.me> |
| In reply to | #109140 |
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
[toc] | [prev] | [next] | [standalone]
| From | Munster <hangerjj@gmail.com> |
|---|---|
| Date | 2016-08-02 17:31 -0700 |
| Message-ID | <ac1c408f-96a9-4c44-a3b4-f7020dbf23c2@googlegroups.com> |
| In reply to | #109141 |
Thanks for your help again! The array formula worked.
[toc] | [prev] | [next] | [standalone]
| From | banhtrungthu68 <banhtrungthu68@gmail.com> |
|---|---|
| Date | 2016-08-02 13:22 +0100 |
| Message-ID | <banhtrungthu68.11e64c38@excelbanter.com> |
| In reply to | #109137 |
_โง________________________________________________โง_ โงโง________________________________________________โงโง โงโง________________________________________________โงโง _โงโง_____________________________________________โงโง__ ___โงโงโง_______________________________________โงโงโง____ _____โงโงโงโง_______________โงโงโงโงโงโง_____________โงโงโงโง_____ ______โงโงโงโงโงโงโง_________โงโงโงโงโงโงโงโงโงโง________โงโงโงโงโงโง______ _________โงโงโงโงโงโงโง_____โงโงโงโงโงโงโงโงโงโงโง___โงโงโงโงโงโงโงโงโง________ ___________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง___________ _______________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง____________ ________________โงโงโงโงโงโง222222222โงโงโงโงโงโง_______________ ________________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง_______________ ________________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง_______________ _______________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง______________ _______________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง______________ _______________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง_____________ ______________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง_____________ ______________โงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโงโง____________ ______________โงโงโงโง__โงโงโงโงโงโงโงโงโงโงโงโงโง___โงโง______________ ____________________โงโงโงโงโงโงโงโงโงโงโงโงโง___________________ ____________________โงโงโงโงโงโงโงโงโงโงโงโงโง___________________ ____________________โงโงโงโงโงโงโงโงโงโงโงโง____________________ _____________________โงโงโงโงโงโงโงโงโงโงโง____________________ _____________________โงโงโงโงโงโงโงโงโงโงโง____________________ ______________________โงโงโงโงโงโงโงโงโง_____________________ ______________________โงโงโงโงโงโงโงโง______________________ _______________________โงโงโงโงโงโงโง______________________ _______________________โงโงโงโงโงโง_______________________ _______________________โงโงโงโงโงโง_______________________ ______________________โงโงโงโงโงโงโงโง______________________ ______________________โงโงโงโงโงโงโงโง______________________ _____________________โงโงโงโงโงโงโงโงโงโง_____________________ ____________________โงโงโงโงโงโงโงโงโงโงโง_____________________ ___________________โงโงโงโงโงโง_โงโงโงโงโงโง____________________ ___________________โงโงโงโง_____โงโงโงโง____________________ __________________โงโงโงโงโงโง___โงโงโงโงโงโง___________________ -- banhtrungthu68
[toc] | [prev] | [next] | [standalone]
| From | banhtrungthu247 <banhtrungthu247@gmail.com> |
|---|---|
| Date | 2016-08-03 12:27 +0100 |
| Message-ID | <banhtrungthu247.11e78fa8@excelbanter.com> |
| In reply to | #109137 |
_________@@@@@@@@_____ _____@@@@@@____________ ___@@@@@@______________ __@@@@@@@_____________ ___@@@@@@______________ _____@@@@@@____________ _________@@@@@@@@_____ ___________________________ ______@@@@@@@@@_______ __@@@@@_______@@@@@__ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ __@@@@@_______@@@@@__ ______@@@@@@@@@_______ ___________________________ ______@@@@@@@@@_______ __@@@@@_______@@@@@__ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ _@@@@@_________@@@@@_ __@@@@@_______@@@@@__ ______@@@@@@@@@_______ ________________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@________________ __@@@@@@@@@@@@@@___ __@@@@@@@@@@@@@@___ __@@@@@@@@@@@@@@___. -- banhtrungthu247
[toc] | [prev] | [standalone]
Back to top | Article view | microsoft.public.excel.programming
csiph-web