HELP!! Using Vlookup

[chrisaustralia]

Hi All. Ok, this is kinda complex, well it is in my eyes anyway.

I have an excel spreadsheet with 2 tabs. What i need 2 do in one tab there is all this raw data. And it goes horizontally. In column J, there is a job number, and this usually goes down 5 rows. In column 0, there are different fields being, typesetting and formatting, revisions, account service, PDFs, Colour Print.
In the other tab, I am trying to put these fields vertical. What I am needing is that when the job number is looked up, it will also reference column 0 and put that figure in. The total figure is in column S in the second Tab. And the figure has to go in column N in the first tab.

Bear in mind that the First row on both tabs is a heading row.

Hope someone can help. Let me know if you require more information.

 

[HalfAce]

My guess would be that the code is not where it needs to be.
Have you installed it into a standard module in this workbook?
(Pressed F9 to calculate the sheet?)

The expected results & symtoms would be as follows.
#VALUE! - (named range incorrect or missing)
#NAME? - (code is not installed, or otherwise inaccessible)
A value but the wrong one - (The column index or row argument(s) (the last two
arguments in the formula) are incorrect.
The text 'Not Found' - (The lookup value is not found in the first column of the lookup table.
The desired value. - (All is cool )

Do any of these help?

 

[chrisaustralia]

It works now....

Was just me being silly, and making the lsightest error....thanks heaps Halface...

 

[HalfAce]

You're most welcome. Glad it helped.
(And as you've seen, there are no 'slight' errors in programming. It's like math, either
it works or it don't) :wink: