GrilledCheese
Board Regular
- Joined
- Apr 23, 2014
- Messages
- 75
I have a formula =OFFSET(INDEX('[Sales.xls]Sheet1'!$A:$A,MATCH($A8,'[Sales.xls]Sheet1'!$A:$A,0)),1,4). The Sales workbook is the source workbook. The $A8 in the formula is located on the destination workbook. If I insert a column in column B on the source workbook, the formula will not pull the previous lookup value. What can I do to my formula so that it will pull the same lookup value even if I insert a new column?