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. I'll call it StateCity for illustration
The resulting table would then look like:
A B C D E
1 StateCity State City Hotel Car
2 co denver 88 23
3 ca menlo 90 45
4 nb denver 1000 12
In cell A2 enter =B2&C2, and copy into A3 and A4 so that the strings
codenver, camenlo, and nbdenver appear in A2, A3 and A4.
Then you can do a table lookup based on column A which is sort of the
"AND" of B and C.
Hope this is clear and that it is helpful.
Don
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
