View Single Post
 
Old 06-01-2022, 10:20 PM
chittari chittari is offline Windows 11 Office 2016
Novice
 
Join Date: Jun 2022
Posts: 3
chittari is on a distinguished road
Default 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
Reply With Quote