Min indext match formula please help

kevatarvind

Well-known Member
Joined
Mar 3, 2013
Messages
1,047
Office Version
  1. 365
Platform
  1. Windows
Hello All,

Please see below table i want min value i have put manually but how to get using index match formula i have tried lots of formula but not getting any single formula to get this i used below formula


=INDEX(B4:D9,MATCH(MIN(B4:B9),B4:B9,0),MATCH(F4,B3:D3,0)) but its working for one column i copy down then not working bcoz next i have to loook in column C For Airtel

Please help thanks in advnace


Excel 2010
ABCDEFGH
3TYPEBSNLAIRTELIDEAWant A Formula hereMannualy
4LANDLINE499599699BSNL299
5MOBIEL99910991199AIRTEL399
6POSTPAID8299291029IDEA499
7PREPAID299399499
83G399499599
92G599699799
Pricing
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Can Any Body Please Help On This its Very Urgent please
 
Upvote 0
depending on the version of excel you're using


Excel 2012
ABCDEFGHI
1TYPEBSNLAIRTELIDEA20072010Mannualy
2LANDLINE499599699BSNL299299299
3MOBIEL99910991199AIRTEL399399399
4POSTPAID8299291029IDEA499499499
5PREPAID299399499
63G399499599
72G599699799

<tbody>
</tbody>
Sheet5

Worksheet Formulas
CellFormula
H2=AGGREGATE(15,6,$B$2:$D$7/($B$1:$D$1=F2),1)

<tbody>
</tbody>

<tbody>
</tbody>

Array Formulas
CellFormula
G2{=MIN(IF($B$1:$D$1=$F2,$B$2:$D$7))}

<tbody>
</tbody>
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

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
Back
Top