VLOOKUP pulling data from different worksheets

[NDmad]

I am putting an equation in one worksheet in my excel document that involves division and putting the VLOOKUP equation in the denominator. This is what my equation is:

=(I13)/(VLOOKUP('v2.0 735con'!"grand total",$A:$E,5,false)+vlookup('v2.0 gt'!"total current",$A:$E,5,false))

The 'v2.0 735con'! and 'v2.0 gt'! pop up in the equation every time I jump from worksheet to worksheet within the same excel doc. When I hit enter to get the answer I get an error message saying "Not trying to type a formula?" and it highlights the "grand part in my equation, as if that was the part of the equation that needed revision.

I'm not seeing it.... Or is it not possible to do VLOOKUPs when pulling data from different worksheets?

Thanks

[mikeTRON]

It is possible to do vlookups from other worksheets AND other workbooks, but your formatting is incorrect.
I took a stab at what I thought you MIGHT be doing below.

Please Login or Register  to view this content.

This assumes the "Grand Total" and "Total Current" are what you are trying to look up from sheets v2.0 735con and v2.0 gt, respectively.