Forum Discussion
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...
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))*
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))*
WOW. Thank you so very much. i guess I'm dumb as a rock. :-).
i tried both formulas' and they work on my spread sheet just fine.
I think the "*" at the end of the second formula was an extra character?
I don't understand why in the first match string that Table7[[#All],[month] was needed
and for the second match string Table7[#Headers] was good
anyway, I'm thankful for the help, and i'll play around and try to learn more.
thank you so very much ... :-)