Forum Discussion
Re: Welcome to the Excel Community
I had a problem in excel using Index and match I had this data
L M N O
55 Entity Revenue 2013 Revenue 2014 Revenue 2015
56 Company A 10,200 10,404 10,924
57 Company B 2,450 12,485 13,109
58 Company C 14,688 14,982 8,500
59 Company D 17,626 6,500 18,877
I had seleced Renue using list
And Also selected minimum for the year usings IFS function
But Whn I need to get Company details for Revenue for particular year with minimum revenue using Index Match Im not getting the result
Can sombody Help Me?
L M N O
55 Entity Revenue 2013 Revenue 2014 Revenue 2015
56 Company A 10,200 10,404 10,924
57 Company B 2,450 12,485 13,109
58 Company C 14,688 14,982 8,500
59 Company D 17,626 6,500 18,877
I had seleced Renue using list
And Also selected minimum for the year usings IFS function
But Whn I need to get Company details for Revenue for particular year with minimum revenue using Index Match Im not getting the result
Can sombody Help Me?
1 Reply
See the attached demo workbook.
