Rounding criteria within a nested vlookup and hlookup

[Guest]

I am working to track commodities markets. Basically the situation is this:
- I enter market pricing information for the two commodity markets in 4
decimal places
- From there I have a separate chart with one commodity market on the x-axis
and one commodity market on the y-axis.
- The row heading is rounded to nearest $.01
- The column heading is rounded to nearest $.05

When I enter the market prices for the commodities, I want to pull our
pricing from our supplier. So, it is the intersection of the one market
price, rounded to nearest $.01, and the other market price, rounded to
nearest $.05.

My formula is currently:
=VLOOKUP(MROUND(B11,0.01),'Item 12970'!A974,HLOOKUP(MROUND('Cost
Savings'!C11,0.05),'Item 12970'!B875,68,FALSE),FALSE)

However, for certain values entered into B11 or C11, I get a #NA error and I
can not figure out why.

Any ideas?

 

[Bob Phillips]

Maybe

=VLOOKUP(MROUND(B11,0.01),'Item 12970'!$A$9:$P$74,HLOOKUP(MROUND('Cost
Savings'!C11,0.05),'Item 12970'!$B$8:$P$75,68,FALSE),FALSE)


--

HTH

RP
(remove nothere from the email address if mailing direct)