LOOKUP logic assistance needed to return value

Aksaboutme

New member
Joined
Jul 10, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2018
class 1 25% Limit Min class 1 Min class 2 Min class 3
class 2 50% 250,000 1,350 1,575 1,800
class 3 25% 500,000 1,800 2,125 2,500
1,000,000 2,250 2,600 3,375
2,000,000 2,600 3,000 4,050
Limit 250,000 3,000,000 2,880 3,375 7,500
min ????? Amount 6,000 4,000,000 4,900 6,500 6,250
5,000,000 4,320 5,400 9,900
6,000,000 6,500 8,100 8,400
7,000,000 5,760 7,200 11,000
8,000,000 7,200 9,000 13,350
9,000,000 8,500 10,600 15,500
10,000,000 9,650 12,000 17,650

-----------------------------------------------------------------------------------------------------------------

If you cannot view please look at the attached


Essentially what I am trying to do is create a logic which would return the highest min class value(from the table). However this depends on whether class 1/2/3 are filled(top left), for example as the limit entered is 250,000, then we must look towards the first row, and since class 1,2,3 all have values in them, then i wish to return min class 3 (1800)

BUT

if it were to be

CLASS 1 50%
CLASS 2 50%
CLASS 3 0%

then i wish to return min class 2 (1575)
Please do look at the attached

Thanks
 

Attachments

  • Book1.xlsx
    8.9 KB · Views: 5
Cross-posted

This query has been cross-posted on at least one other forum. You are required to provide links to any such posts. Please do so now.
 
Back
Top