I have two indirect references inside of an Index and Match formula. It is returning an Error Message. Please help!
This is the formula I've pieced together... G2 is the cell that will be updated that references another sheet. K is the return value, B is the match column, and C2 is the match value.
Here is link to sample spreadsheet.
=INDEX((INDIRECT("'"&$G$1&"'!$K:$K"),(MATCH($C2,INDIRECT("'"&$G$1&"'!$B:$B",0)))))