The formula is now working appropriately even though I don't understand why.
Thank you for that formula, it is a good one.

I had checked the formatting of all sections prior to sending this question
out and double checked them yesterday. Then I copied a cell below where the
#VALUE! error first occurred which worked for the new figure then I changed
it back to the figure I wanted to be looked up in the formula. Now all the
cells are working accurately.

Kristin
"Max" wrote:

Check for residual/formula returned errors (#VALUE!) in your lookup data and
in your reference col F data. Clean these up and all should be well.
--
Max
Singapore
---
"Kristin" wrote:
Still getting #VALUE! error. Anything else you can think of?