I am trying to use either MATCH or VLOOKUP to lookup data, the trouble I am having is when the lookup value is not exact. I don't wan't the nearest value, instead I wan't a default number.
However if the field being evaluated is blank, then I don't want the formula to run...
can anyone help?
However if the field being evaluated is blank, then I don't want the formula to run...
can anyone help?