Looking up 2 tables

[dpaton05]

I have a cell that needs to lookup two tables to find the price. It needs to lookup the time of week (such as mon-fri, weekend or public holiday), type of service and type of location (metro, regional or remote). I have two tables to show this info but is there a formula that allows you to reference two tables to find an answer?

 

[dpaton05]

These are on the axis of the two tables:

table 1
Time of week * type of location

table 2
Time of week * type of service

 

[Fazza]

How does that work?
I don't see the price?

 

[Fazza]

please post a sample - so a few rows of data in each table - that matches what is wanted

 

[dpaton05]

How do I upload a picture of the table?

 

[Fazza]

Pictures aren't much help - as can't be copied usefully into Excel.
Have a look at the sticky threads & "how to" posts for the forum.

 

[dpaton05]

Where are they, I can't find them?

 

[dpaton05]

Just found them. I will have to wait until i get home from work to upload the picture.

 

[dpaton05]

Here it is. https://www.screencast.com/t/xGfM3Rd36M