work sheet funtions

[Saako]

Hi guys,
Am a new-b here as am a new-b in excel. I am here to get some assistance to heve my function as I want them to work.
I have created a work sheet that has to show week cash flow in a locak currency. this is no problem at all. A similar sheet has to be created for the same business entity converting/reporting all cash in Euros. I have used a Vlookup function which works great; ie when I enter the values in my local currency these are automatically converted to Euros. The problem comes in here when I effect any changes in/on the Euro sheet these changes do not make any changes in the local currency. How can I resolve this? I would like this to show the change as well in the local currency automatically
Baby; Saako
I dont know whether the function will help in locating the error well its her: ='Company (Dkkr)'!E18/($C$3/100)

[JBeaucaire]

Without implementing some hefty macro assistance, you can only look up one direction or the other. The sheet that has the local data is being read by the Euros converted sheet. That means any changes to data need to be made on the local sheets, too.