Navigation: FXLV4SpeedTools > Lookup and Match Functions >

Better, Safer Lookup Defaults

 

 

 

Better, Safer Lookup Defaults

All the SpeedTools lookup and match functions default to unsorted exact match, since that is the safest option. Excel’s VLOOKUP and MATCH default to sorted approximate match, which is likely to give incorrect answers in most cases!

 

 

 

Copyright © 2023 Decision Models Ltd