I have a table that has 2 rows of information for each month. Using the ctrl key, I selected the alternating rows and named the entire selection.
I am using index/match formula and I have inserted the named region in the match portion of the formula. However, I keep getting an N/A. Can you not use named regions isf the rows do not immediately follow?
Named region = test
=Index(Stats!b1:b19,match(a2,test,0))
Any ideas on what I might try?
Thanks!
I am using index/match formula and I have inserted the named region in the match portion of the formula. However, I keep getting an N/A. Can you not use named regions isf the rows do not immediately follow?
Named region = test
=Index(Stats!b1:b19,match(a2,test,0))
Any ideas on what I might try?
Thanks!