uberathlete
Board Regular
- Joined
- Jul 11, 2007
- Messages
- 117
Hi guys, I have a question. Say in Sheet 1 I have a formula like this:
=VLOOKUP(F2,$A$2:$D$7,2,FALSE)
which depends on the data array $A$2:$D$7.
I will use the same formula in other sheets but the data array will change. Like for example, in Sheet 2, the data array is $A$2:$D$15, so the formula I need would be =VLOOKUP(F2,$A$2:$D$15,2,FALSE).
And so on and so forth for other sheets that have a different data array in terms of vertical size. Since there are so many sheets, I don't really want to manually change the array every time. So is there an easy way to change it automatically? Basically I just want the array to change based on the vertical size of the array regardless of the formula.
Any suggestions would be greatly appreciated. Thanks!
=VLOOKUP(F2,$A$2:$D$7,2,FALSE)
which depends on the data array $A$2:$D$7.
I will use the same formula in other sheets but the data array will change. Like for example, in Sheet 2, the data array is $A$2:$D$15, so the formula I need would be =VLOOKUP(F2,$A$2:$D$15,2,FALSE).
And so on and so forth for other sheets that have a different data array in terms of vertical size. Since there are so many sheets, I don't really want to manually change the array every time. So is there an easy way to change it automatically? Basically I just want the array to change based on the vertical size of the array regardless of the formula.
Any suggestions would be greatly appreciated. Thanks!