Excel Excel - VLOOKUP issue

A

Aposs

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
 
Stoneboysteve

Stoneboysteve

Joined
Sep 3, 2008
Messages
164
Reaction score
5
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Excel Excel VLookup... 2
Excel Excel Vlookup formula based on cell data 7
Excel Trying to do a vlookup with a nested right function on the array 3
vlookup problem??? 3
Combining IF Statement and Vlookup 0
Execute a statement if certain criteria is met 2
vlookup only part of the string in the cell 3

Top