Calculators
Testing some calculators for advisors.
Error:
Unknown formula element: "_xlfn.xlookup"
- Summary.B11=_xlfn.xlookup([.B3];[$RMDs.C4:.C54];[$RMDs.G4:.G54];;-1;1)*[.B5]
- RMDs.D4=IF([.C4]="";"";IF(AND([$Summary.$B$1]>=21916;[.C4]<75);"";_xlfn.xlookup([.$C4];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D5=IF([.C5]="";"";IF(AND([$Summary.$B$1]>=21916;[.C5]<75);"";_xlfn.xlookup([.$C5];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D6=IF([.C6]="";"";IF(AND([$Summary.$B$1]>=21916;[.C6]<75);"";_xlfn.xlookup([.$C6];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D7=IF([.C7]="";"";IF(AND([$Summary.$B$1]>=21916;[.C7]<75);"";_xlfn.xlookup([.$C7];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
- RMDs.D8=IF([.C8]="";"";IF(AND([$Summary.$B$1]>=21916;[.C8]<75);"";_xlfn.xlookup([.$C8];[$'RMD Factors'.B:.B];[$'RMD Factors'.C:.C];"";-1)))
Demo
