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 88 23 ca menlo 90 45 nb denver 1000 12 for example. In another sheet i want to have 3 cells that i can modify / enter a city, state and type ie.. State nb City denver Type hotel I have this working where i can do a single lookup on the rate table against say city and type using =INDEX(ratedata;MATCH(statename;States;0);MATCH(A6;header;0)) for example. This would work except for where I need that unique combo of both State and City lookup. Can you even do this in a formula or do I need to look at macros ? any pointers would be much appreciated. many thanks Jon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
