Here is the situation using Excel 2007, I have a CODE and QTY in the top row with the code and qty values below on the first page/tab. On the second tab I have many fields names in the top row with different values below them (a suppliers stock update that has descriptions, notes, numbers, etc) .

Can you use Vlookup to search a entire spreadsheet on the second page/tap for the CODE and then if found somewhere find the coresponding QTY on the same row but find the name QTY at the top so that it will use that particular column ? hope I made it clear enough if not I can do some pictures to make it easier.

I assume it can't do this alone and if anyone can point me in the right direction that would be great, thanks.