Excel Excel - VLOOKUP issue

Joined
Sep 22, 2011
Messages
1
Reaction score
0
I am creating a file that I am using a VLOOKUP that is pulling data from 6 different wkshts. I am able to drag the formula down to pull in the different "Row" data but I cannot figure how to drag across to get the column data. I want to be able to get 11,83,83,11,11... in the next column and so on... see below

=VLOOKUP($A344,'Table1'!$A$4:$CB$383,10,FALSE)-VLOOKUP($A344,'Table2'!$A$4:$EV$383,82,FALSE)-VLOOKUP($A344,'Table3'!$A$4:$EV$383,82,FALSE)-VLOOKUP($A344,'Table4'!$A$4:$CB$383,10,FALSE)-VLOOKUP($A344,'Table5'!$A$4:$CB$383,10,FALSE)

Thanks. Poss
 
The 'V' in vlookup is vertical.
There is a hlookup function.

You may be able to use offset or match, please provide more detail on your data and desire.

Stoneboysteve
 
Back
Top