[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
jnocal
Newbie

Joined: 16 May 2012
Posts: 4

 Posted: Wed May 16, 2012 12:52 pm    Post subject: Need help with CALC Formula I've hit the limit on a formula in Calc (Err:512). I am trying to pull data from one spreadsheet into another. One one spreadsheet I have trucking firms and the freight they charge at different destinations. On another spreadsheet I enter loads. I'd like to enter the truck firm and where the load came from. How do I build a formula that will match up the truck and destination from original spreadsheet and enter the appropriate charge?
jnocal
Newbie

Joined: 16 May 2012
Posts: 4

 Posted: Wed May 16, 2012 2:12 pm    Post subject: The more I look into this the more I think this is a VLOOKUP solution. However, I cannot get VLOOKUP to work.
Ed
Super User

Joined: 28 May 2003
Posts: 1041

 Posted: Wed May 16, 2012 2:29 pm    Post subject: Can you post the exact formulae you have tried?
jnocal
Newbie

Joined: 16 May 2012
Posts: 4

 Posted: Wed May 16, 2012 2:36 pm    Post subject: OK - Here is the Formula: =VLOOKUP(Y2;Sheet6.A2:b16;2;0) I actually had it working as part of an =IF function: =IF(F2="Rios";VLOOKUP(Y2;Sheet6.A2:B16;2;0)) However, I want it to look up the values pulled from another spreadsheet (NOT a separate sheet in the same spreadsheet.
jnocal
Newbie

Joined: 16 May 2012
Posts: 4

 Posted: Wed May 16, 2012 8:27 pm    Post subject: Why can't I pull information between files? Here is my formula: =IF(AND(F2="xxxx";OR(G2="yyyyy";G2="wwww"));VLOOKUP(Y2;'file:///C:/Users/Owner/Documents/OTC/Freight Charges.ods'#\$xxx.A2:D16;3;0);0)
ozzie

Joined: 29 Jul 2010
Posts: 402
Location: victoria