Hi guys,
Having trouble with a formula. I have attached my work sample and in "sheet 1" I have highlighted the errors in red. I believe my error has something to do with the length of the first equation being only 6 samples long as the following columns data shows only 6 answers before the #REF! shows.
My formula I am using is
=INDEX((INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$1):INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$2)),MATCH(A2,Sheet2!$O$1:Sheet2!$O$300,0))
which is the equation for cell B2, then copied down.
For cell D2,the equation is
=INDEX((INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$2):INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$3)),MATCH(C2,Sheet2!$O$1:Sheet2!$O$300,0))
, then copied down.
Data is exported from sheet 2.
Thanks for all help.
Bookmarks