On Apr 30, 11:06*pm, Glenn wrote:
Doug wrote:
Not sure why it is not working. Everything you said makes sense, I went back
and checked all the number formats, etc. I will just have to play around and
maybe look up the details to the functions you gave me. *You have helped a
great deal.

Did you just check the number formats, or did you actually confirm that there
are numbers in the cells, following the directions I gave previously?

Also, make sure that the numbers exactly match what you expect them to be, for
example make sure it is .02 in the cell and not .020000001 formatted to show
only 2 decimal places.

Glenn / Doug

The only way I managed to get this to work, was to make sure
'Precision as displayed' was selected in the OPTIONS.

the ROUND function is causing the MATCH function to fail, this seems
to resolve the problem

Regards

David