find a value based on two conditions in a table
Need a quick help below
Based on the following table How to get Carpark charges (using formula) for Surray on Tuesday. Thanks
Seems easy but could not achieve by using if, index, match etc
Carpark charges table:
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Vismai 1.00 1.00 1.00 1.00 1.00 2.00 2.00
Surray 2.00 2.00 2.00 2.00 2.00 2.50 2.50
Sutlej 1.00 1.50 2.00 2.50 3.00 3.50 4.00
Mannera 10.00 9.00 8.00 7.00 6.00 5.00 4.00
|