Forum Discussion
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 headers, and build the same formulas, my column is correct but my rows are off by one.... so my underlying index must be wrong, even though the text match says it is working.
Could someone tell me what is wrong with my table formula, of if this doesn't work on tables. ??
I've spent hours trying to figure this out, and I'm sure it's a two. minute job.
thanks you
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))*
2 Replies
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 ... :-)
