Trying to retrieve Data over multiple Rows and Columns

  • Hi All,


    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.

  • Re: Trying to retrieve Data over multiple Rows and Columns


    Look at each formula, when you copy, move formula's they get altered automatically, you may have to go back into each cell and change where it searches. The best way i have found to do this is to go into "formula Auditing mode" copy all the cells you need to fix the formula from, then open up notepad paste, then manually edit everything, copy again and paste back into the first cell.