Dragging down and moving along colums, not rows

So basically i used the lookup trick Lookup(large number, range) to find the last cell with data in it. But I need it to go from Column B to C, to D etc... when i drag it down. how can I do this?

File is attached. So Column D in Sheet "Brent" is the one appliable. Instead of reading =LOOKUP(999999999,'Data Miner Query'!B$2:B$6556) in D13, I want it to read =LOOKUP(999999999,'Data Miner Query'!C$2:C$6556).

Thanks for any help!!!

It looks like just replacing the B in your formula above with a C works.

Originally Posted by MarvinP

It looks like just replacing the B in your formula above with a C works.

Thanks, but the point is I dont want to manually change it for thousands of entries. So I'd like it to change from B to C to.... AZ for example when I autodrag down.

Put differently, why doesnt this formula work?

=INDEX('Data Miner Query'!1:65536,MATCH('Data Miner Query'!A164,'Data Miner Query'!A:A,FALSE),MATCH('Data Miner Query'!B1,'Data Miner Query'!1:1,FALSE))

File attached, look at D12.

Try offset like in this example:
=COUNTA(OFFSET(Subfamy!$A:$A,0,(ROWS(A$1:A1)-1)))