Match values iin two rows to return the value assocated with one of them

[robbieb777]

I have a row in one sheet which is the number of pages in a newspaper and a second row in another sheet which lists against each pagination a cost. What I want to do is match the values in the rows and where they match return the cost value. Each pagination has a unique cost but the number of pages in the newspaper can be different each day. I want to return the cost for each day. I can't quite get the HLOOKUP formula to get it to return the correct cost value. Can anyone help?

 

[Sancdar]

If you provide a sample of how you have the data arranged that should be no problem. My first thought is that your range term in the HLOOKUP might be covering only the pagination values and not also the cost values, which would mean you can't traverse to the next row in that range once you've matched a value.