Harrywatson
Board Regular
- Joined
- Jan 20, 2014
- Messages
- 92
On a page there are thousands of cells with the formula :
=VLOOKUP($A41, 'ON 13-14 (3)'!$A:$H,COLUMN( ), 0 )
I was wondering how I could quickly change the page reference to 'ON 13-14 (2)' rather than 'ON 13-14 (3)' in all of these cells at once
=VLOOKUP($A41, 'ON 13-14 (3)'!$A:$H,COLUMN( ), 0 )
I was wondering how I could quickly change the page reference to 'ON 13-14 (2)' rather than 'ON 13-14 (3)' in all of these cells at once
