kylefoley76
Well-known Member
- Joined
- Mar 1, 2010
- Messages
- 1,553
The formula I'm using is
But it doesn't work at all on one worksheet, half works on another, and works sometimes on another.
In the worksheet attached called workbook 4, it works a15 sheet 2, but not a10 sheet 2. But that was not always the case. In the worksheet attached justification copy, it works in a14 sheet 4 but not in a10 but for a good while it didn't work in both. In my own private doc it doesn't work in both cases.
https://drive.google.com/file/d/0B9zzW6-3m2qGTTM1aElsX0FuZmc/edit?usp=sharing
https://drive.google.com/file/d/0B9zzW6-3m2qGZUk0aHl6aUZPLVk/edit?usp=sharing
I should also add that I was able to get the formula to work when I stuck with one page
Code:
=SUBSTITUTE(OFFSET(A10,-2,0),VLOOKUP(OFFSET(A10,-1,0),prim!$D$1:$I$263,5),VLOOKUP(OFFSET(A10,-1,0),prim!$D$1:$I$263,6))
But it doesn't work at all on one worksheet, half works on another, and works sometimes on another.
In the worksheet attached called workbook 4, it works a15 sheet 2, but not a10 sheet 2. But that was not always the case. In the worksheet attached justification copy, it works in a14 sheet 4 but not in a10 but for a good while it didn't work in both. In my own private doc it doesn't work in both cases.
https://drive.google.com/file/d/0B9zzW6-3m2qGTTM1aElsX0FuZmc/edit?usp=sharing
https://drive.google.com/file/d/0B9zzW6-3m2qGZUk0aHl6aUZPLVk/edit?usp=sharing
I should also add that I was able to get the formula to work when I stuck with one page