Re: [users] Need some help with Calc and data lookups

2008-04-17 Thread Don Daugherty
Jon, Like you, I'm new to Calc, and more experienced users may have better suggestions, but here is an idea I've used in another spreadsheet: 1. In the first sheet, insert a new column to the left of the first column which I think is actually your State column rather than your City column.

Re: [users] Need some help with Calc and data lookups

2008-04-17 Thread Don Daugherty
Don Daugherty writes again: I see that my use of tabs has screwed=up the appearance so let me re-format what I just sent; Jon, Like you, I'm new to Calc, and more experienced users may have better suggestions, but here is an idea I've used in another spreadsheet: 1. In the first sheet, insert

[users] Need some help with Calc and data lookups

2008-04-12 Thread Bowman Jon
Hi I am pretty new to calc but am trying to accomplish the following ... In one sheet i have a rate table something like city state hotel car co denver 8823 ca menlo 90 45 nb denver 1000 12 for