Finding a value in a row first then a column in excel

[soma34]

I have to admit i thought thered be an easy solution to this but i have struggled.

I have created a pricing chart for a venue that I hire out for parties.

If i have created data where down the left hand side, the data is days of the week, and across the top I have parts of the day, (ie am pm evening) where the data is then all pricing, how can i create a function so that the booking form, where i type in the day of the week and the session will return the value? Vlookup doesnt work becuase it will find the day but then the session of the day can not be searched for, i obviously have to select a column number rather than the function choose the column based on the time of day criteria?

Can anyone help ?

 

[Ken Cowen]

It seems like you will need to use the Match function (twice) and an Offset function. It depends on your inputs, but basically the day input needs to get matched to the column of days, and the other input gets matched to the row of parts of the day and your answer is =OFFSET(top left cell, rows from first match, columns from second match)

I hope this gets you going in the right direction.

Ken