Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109141

Re: Index and Match Help

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: Index and Match Help
Date 2016-08-02 14:56 +0200
Organization A noiseless patient Spider
Message-ID <nnq5ap$bsi$1@dont-email.me> (permalink)
References <3dbdc2cb-b093-4033-bef7-7a637cd320fe@googlegroups.com> <nnp9rq$tnd$1@dont-email.me> <a3b0cc7b-6076-460c-836f-8da3004392a0@googlegroups.com>

Show all headers | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

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

csiph-web