we have Excel Match formulas which looks thru a lookup_array
1) which finds the largest value that is less than or equal to lookup value (match type 1) and
2) which finds the smallest value that is greater than or equal to the lookup value (match type -1)
Eg. of Usage : Supposing we have tank table for liquid A as below. Need to know TankCateg for smallest tank which will hold a 150K gallons liquid A. Using match type -1 in Excel Match function, the tankcateg is 3, capacity 200,000.
Liquid Type A Tanks:
TankCateg Capacity(gals)
1 300,000
2 250,000
3 200,000
4 100,000
5 50,000
6 10,000
We have tanks sizes and category in a table as there are many tank categories and liquid type.
How do we do this in Anaplan?
Thank you,
Cheng