Module vs VLookup

[TANKERMAN]

Hey All,

Sheet "Reference Tanks" contains 13 rows, 80 columns. Row 1 contains the Tank Names. In column 1A is the tank name, in 2A:13A contains reference gauges for the tank AND 2B:13B contains the max difference for the tank, these are static gauges. Each tank has 2 columns we have 40 tanks.

Sheet "Tank Gauge" is where I need to populate. I need to enter a tank name in Cell 3F and have 9B:18B and 9C:18C populate.

[wallyeye]

This should do it for you:

=OFFSET('Reference Tanks'!A$2,ROW()-ROW($9:$9),MATCH($F$3,'Reference Tanks'!$A$1:$J$1,0)-1)

You will just need to change the Match to reference your full range of tank names instead of just $A$1:$J$1.