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

Index and Match Help

Newsgroups	microsoft.public.excel.programming
Date	2016-08-01 19:54 -0700
Message-ID	<3dbdc2cb-b093-4033-bef7-7a637cd320fe@googlegroups.com> (permalink)
Subject	Index and Match Help
From	Munster <hangerjj@gmail.com>

Show all headers | View raw

  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.

Back to microsoft.public.excel.programming | Previous | Next — 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