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.
--
Thank you!


"Glenn" wrote:

Doug wrote:
I am recieving a #N/A in the field. This is what it looks like now that I
modified it to fit what I am doing. Can you see what may be wrong? $E$8 is
the lookup value and the table is in $P$2:$Z$41.

=INDEX($Q$3:$Z$41,MATCH(ROUND($E$8,1),$P$3:$P$41,0 ),MATCH($E$8-ROUND($E$8,1),$Q$2:$Z$2,0))


If MATCH is unsuccessful in finding a match, it returns the #N/A error value.

Make sure that what looks like a number is actually a number (and not text) in
cell E8, column P and row 2.

One way to convert them would be to copy a blank cell, select the values in
question, then Edit / Paste Special / Values / Add / OK. This will not change
cells that are already numbers.
.