azizrasul
Well-known Member
- Joined
- Jul 7, 2003
- Messages
- 1,304
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
I have the following formula (which works).
=IFERROR(MATCH(SUMIFS('Benefit Export'!$K:$K,'Benefit Export'!$B:$B,B$4,'Benefit Export'!$H:$H,1,'Benefit Export'!$E:$E,"Member",'Benefit Export'!$I:$I,"Individual",'Benefit Export'!$A:$A,3000724),Current!Dental_Max,0),1)
The value of 3000724 is a customer number in a sheet called 'Benefit Export' in column A. However there are many customer numbers in column A and I want to obtain this value based on the smallest length of customer number and add that bit of formula instead of hard wiring the customer number as I have now. Any help would be appreciated.
=IFERROR(MATCH(SUMIFS('Benefit Export'!$K:$K,'Benefit Export'!$B:$B,B$4,'Benefit Export'!$H:$H,1,'Benefit Export'!$E:$E,"Member",'Benefit Export'!$I:$I,"Individual",'Benefit Export'!$A:$A,3000724),Current!Dental_Max,0),1)
The value of 3000724 is a customer number in a sheet called 'Benefit Export' in column A. However there are many customer numbers in column A and I want to obtain this value based on the smallest length of customer number and add that bit of formula instead of hard wiring the customer number as I have now. Any help would be appreciated.
Last edited:
