Index Match Formulas
Hi,
I have a problem with picking up rates. I have an average rate and i need to pull from a table the closest fixed rate to the average. I have a jobcode reference i need to use as well as a step. I have attached a sample of the problem. I however have got hundreds of lines of this with many different rates and codes etc.
I ahve tried to use INDEX(MATCH.......formula but i cannot seem to get it to work.
Any help would be welcomed.
Thanks in advance,
john
|