Forum Discussion

frederick wheeler's avatar
frederick wheeler
Copper Contributor
Oct 10, 2017
Solved

INDEX MATCH MATCH

Hi,    I can get the Index Match Match function to return the correct answer in just a plain data cells ( rows and columns of data) ,  but when I take the same data and insert a DataTable with head...
Formulas & Functions
Requests
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Oct 10, 2017

    Frederick,

     

    either:

    =INDEX(Table7[[cookies packs sold]:[revenue]],MATCH(G15,Table7[month],0),MATCH(G16,Table7[[#Headers],[cookies packs sold]:[revenue]],0))

    or:

    =INDEX(Table7[#All],MATCH(G15,Table7[[#All],[month]],0),MATCH(G16,Table7[#Headers],0))*

     

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 10, 2017

Frederick,

 

either:

=INDEX(Table7[[cookies packs sold]:[revenue]],MATCH(G15,Table7[month],0),MATCH(G16,Table7[[#Headers],[cookies packs sold]:[revenue]],0))

or:

=INDEX(Table7[#All],MATCH(G15,Table7[[#All],[month]],0),MATCH(G16,Table7[#Headers],0))*

 

 

Resources