Need help for below Formula for Index and match

msarfaraz

New Member
Joined
Oct 18, 2012
Messages
46
If value require for A1 when date is match i.e. example below, formula require for red font cell
01/01/201601/02/201601/03/201601/04/201601/05/201601/06/201601/07/201601/08/201601/09/2016
A405060708090100110120
B12252525252525232
C1222225252
D985122564
01/02/201601/04/201601/05/201601/10/201601/07/201601/09/201601/12/201601/14/201601/15/2016
A5070800100120000
B2525205232000
C222022000
D812054000

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

RCBricker

Well-known Member
Joined
Feb 4, 2003
Messages
1,560
If value require for A1 when date is match i.e. example below, formula require for red font cell
01/01/201601/02/201601/03/201601/04/201601/05/201601/06/201601/07/201601/08/201601/09/2016
A405060708090100110120
B12252525252525232
C1222225252
D985122564
01/02/201601/04/201601/05/201601/10/201601/07/201601/09/201601/12/201601/14/201601/15/2016
A5070800100120000
B2525205232000
C222022000
D812054000

<tbody>
</tbody>

be sure to change the range references to suit your needs.

Code:
=INDEX($B$2:$J$5,MATCH($A7,$A$2:$A$5,0),MATCH(B$6,$B$1:$J$1,0))

thanks,
 

RCBricker

Well-known Member
Joined
Feb 4, 2003
Messages
1,560
many thanks, when the date is not find its showing error #N/A can it be 0

here you go

Code:
=IF(ISERROR(INDEX($B$2:$J$5,MATCH($A7,$A$2:$A$5,0),MATCH(B$6,$B$1:$J$1,0))),0,INDEX($B$2:$J$5,MATCH($A7,$A$2:$A$5,0),MATCH(B$6,$B$1:$J$1,0)))

thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,127,199
Messages
5,623,323
Members
415,966
Latest member
ctorohuamanchumo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top