#### uberathlete

##### Board Regular

- Joined
- Jul 11, 2007

- Messages
- 117

=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!