I am a real newbie to Excel and I am trying to get an INDEX/MATCH formula to work over multiple Rows and Columns. I am not even sure if that is the correct formula for what I am trying to do.
This is the formula I have so far: =INDEX('CURRENT & PENDING'!$E$7:$T$700;MATCH($A$17;'CURRENT & PENDING'!$F$7:$F$700;0);1). The formula works fine until I copy it horizontally, it then gives me the same answer no matter the other sheet has in it.
I am not sure I am explaining the issue 100 percent.