kevatarvind
Well-known Member
- Joined
- Mar 3, 2013
- Messages
- 1,047
- Office Version
- 365
- Platform
- 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
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 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
3 | TYPE | BSNL | AIRTEL | IDEA | Want A Formula here | Mannualy | ||||
4 | LANDLINE | 499 | 599 | 699 | BSNL | 299 | ||||
5 | MOBIEL | 999 | 1099 | 1199 | AIRTEL | 399 | ||||
6 | POSTPAID | 829 | 929 | 1029 | IDEA | 499 | ||||
7 | PREPAID | 299 | 399 | 499 | ||||||
8 | 3G | 399 | 499 | 599 | ||||||
9 | 2G | 599 | 699 | 799 | ||||||
Pricing |