dfolzenlogen
New Member
- Joined
- Oct 18, 2009
- Messages
- 36
Hi,
I have a workbook which contains 2 worksheets: 1 called MIPA and another called Dashboard Data. I am using Index Match formulas on several columns on the MIPA worksheet which refers to a named range on the Dashboard Data worksheet called Data (the data) and another named range called LineNo (the unique info). The formula I'm using is below:
// =IFERROR(INDEX(Data,MATCH($A84,LineNo,0),COLUMN($AM84)),"Nomatch") //
The formula works just fine but whenever I insert a column on the MIPA worksheet, my absolute column references to data in the DashboardData worksheet keep changing. What am I doing wrong?
Any help would be appreciated.
I have a workbook which contains 2 worksheets: 1 called MIPA and another called Dashboard Data. I am using Index Match formulas on several columns on the MIPA worksheet which refers to a named range on the Dashboard Data worksheet called Data (the data) and another named range called LineNo (the unique info). The formula I'm using is below:
// =IFERROR(INDEX(Data,MATCH($A84,LineNo,0),COLUMN($AM84)),"Nomatch") //
The formula works just fine but whenever I insert a column on the MIPA worksheet, my absolute column references to data in the DashboardData worksheet keep changing. What am I doing wrong?
Any help would be appreciated.
Last edited: