Calc lookup results and boundaries
Look up left-hand values and matrix intersections while checking duplicate keys, blank results and sorted bands.
Return a Calc value from the left of its lookup key
Find an exact key in an unsorted right-hand column and read the corresponding name.
Read a Calc matrix by both row and column labels
Use two exact positions to retrieve one supplied table value.
Stop a Calc lookup when its key matches twice
Count exact key matches before choosing a return value.
Keep a blank Calc lookup result distinct from zero
Inspect the matched return cell’s state before reporting its value.
Use a sorted boundary table for a Calc band lookup
Read one lower-inclusive band from a supplied increasing table.