Vlookup and workbook sheet referencing in 2007

Hi esupply,

I'm not exactly sure what you are asking here, but I think you need to include "Sheet2!" in your references.

Example:
=SUM(A1:A5), will sum the first five rows in column A for the sheet in which the formula is typed.

=SUM(Sheet2!A1:A5) will return the sum of the first five rows in column A of Sheet 2 regardless of whst sheet you entre the formula

For you example I think you will need to type somthing like teh following into G2 on Sheet1.

=INDEX(Sheet2!$A$5:$BE43870,MATCH($C$2,$B$12:$B43870,0),MATCH($E$2,Sheet2!$A$4:$BE$4,1))


Hope this helps

Also, just looking at your workbook it might be a little easier if you used a HLOOKUP function.

for F2 somthing like:
=HLOOKUP(E2,$G$11:$BK$18,MATCH(C2,Sheet1!$B$11:$B$18,FALSE),FALSE)

and for G2 somthing like:
=HLOOKUP(E2,Sheet2!$A$4:$BE$11,MATCH(C2,Sheet1!$B$11:$B$18,FALSE),FALSE)

Ok thanks ill give them a try,,ill keep you posted,,,

thanks Hammertime,
your forst post with the index formula works great