#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Excel sheet with the data as attached
|
#4
|
|||
|
|||
thanks for your reply
Just done that, Thanks for your reply.
|
#5
|
|||
|
|||
It's how I would do this!
|
#6
|
||||
|
||||
try in C2:
=INDEX($F$3:$L$6,MATCH($A2,$E$3:$E$6,0),MATCH($B2, $F$2:$L$2,0)) copy down. |
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 |
How to Subtract value in table, based on two different conditions | nitemath2 | Excel | 1 | 06-19-2015 01:28 AM |