I'm using index and match with the following formula: =INDEX($B$95:$F$110,MATCH(L95,$L$95:$L$132,0),1). Unfortunately, it only seems to work sporadically (sometimes skipping rows/gives me a reference error after i drag past the index array). I think the problems are due to the fact that my match lookup array and my index array are different sizes. Any suggestions?
Bookmarks