Forum Discussion
Trying to write a formula
I have a formula where it looks up a VLookup. However, it is not recognising some of the values.
For example the values 30 pp to 99 pp is not recognised and it applies the formula as if it is a 200...
Hi Brian,
With range lookup = TRUE the first column shall be sorted in ascending order, in your case like
100 pp 200 pp 30 pp 300 pp etc.