Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 06-01-2022, 11:43 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline find a value based on two conditions in a table Windows 7 64bit find a value based on two conditions in a table Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
Please post a sample sheet with some data and manually added expected results. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 06-02-2022, 12:24 AM
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

Excel sheet with the data as attached
Attached Files
File Type: xlsx Book1.xlsx (9.5 KB, 5 views)
Reply With Quote
  #4  
Old 06-02-2022, 12:25 AM
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 thanks for your reply

Quote:
Originally Posted by Pecoflyer View Post
Hi and welcome
Please post a sample sheet with some data and manually added expected results. Thx
Just done that, Thanks for your reply.
Reply With Quote
  #5  
Old 06-02-2022, 04:38 AM
ArviLaanemets ArviLaanemets is offline find a value based on two conditions in a table Windows 8 find a value based on two conditions in a table Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

It's how I would do this!
Attached Files
File Type: xlsx Carpark.xlsx (14.5 KB, 7 views)
Reply With Quote
  #6  
Old 06-02-2022, 10:09 AM
p45cal's Avatar
p45cal p45cal is offline find a value based on two conditions in a table Windows 10 find a value based on two conditions in a table Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

try in C2:
=INDEX($F$3:$L$6,MATCH($A2,$E$3:$E$6,0),MATCH($B2, $F$2:$L$2,0))
copy down.
Reply With Quote
Reply

Thread Tools
Display Modes


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 11:20 AM.


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