Dragging formulas

Hi all,

What I want to do is drag a formula down a column that relates to a row of data on another spreadsheet.

For example, my spreadsheet is attached. I want to go to the tab called Chatham Gen Haul and put a formula in cell G8, I have simply done this:

='Vehicles by Type MPG'!D8

This relates to the tab Vehicles by Type MPG

So, after entering this formula I drag it down the column in the spreadsheet but what I want it to do is as I drag it down the formula would do something like this:

Say in cell G9:
='Vehicles by Type MPG'!E8

In cell G10
='Vehicles by Type MPG'!F8

But it's not doing it, any idea where I'm going wrong?

Thanks,
Lewis

Try this in G8 and filled down.

=OFFSET('Vehicles by Type MPG'!$D$8,0,ROWS(A$1:A1)-1)


Don't change the A$1:A1 reference, it's not related to your data.

Or this would be even simpler.

=LOOKUP($D8,'Vehicles by Type MPG'!$D$7:$BC$8)

Works great, thank you

You're welcome.

Ignore my first suggestion, it's very inefficient. Given that you have index numbers already present on both sheets that can be used.
The other 2 suggestions are much better.