Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-01-2022, 10:20 PM
chittari chittari is offline find a value based on two conditions in a table Windows 11 find a value based on two conditions in a table Office 2016
Novice
find a value based on two conditions in a table
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to make sum based on multiple conditions, HELP! ilsel Excel 3 11-15-2017 02:03 AM
Find and Replace rows in a table based on bold text. OfficeAssociate99 Word VBA 4 07-26-2017 07:20 AM
Find and Replace rows in a table based on bold text. OfficeAssociate99 Word VBA 2 07-26-2017 06:32 AM
Index to return value based on 2 conditions george batshon Excel 2 01-28-2017 05:11 AM
find a value based on two conditions in a table How to Subtract value in table, based on two different conditions nitemath2 Excel 1 06-19-2015 01:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft