HLOOKUP help

[Robbieb777]

HLookup help



Below are two separate sheets, the first one is the number of pages in a newspaper each day for two weeks. The table below that is the cost for each pagination. So what I want is to replicate the first table but with the appropriate cost depending on it looking up the number of pages from table 2 and returning the correct cost figure. I figure HLOOKUP is the way to go but can't quite get it to return the cost figure only the pagination.

Monday Tuesday Wednesday Thursday Friday Saturday

Wk32 48 64 48 48 64 64
Wk31 36 56 48 48 56 64


Pagination 36 40 44 48 52 56 64
Price per copy 1.1 1.2 1.3 1.4 1.5 1.6 1.7


Hope someone can help.
Thanks.

[Yogi52o]

Let's see your HLOOKUP code that's returning the pagination. Most likely, you have something of the format Hlookup(Lookupvalue, lookuparray, 1), when what you really want is Hlookup(Lookupvalue, lookuparray, 2,1)