+ Reply to Thread
Results 1 to 2 of 2

HLookup help

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Cambridge
    MS-Off Ver
    2010
    Posts
    1

    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.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Robbieb777,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. HLOOKUP Help. HLOOKUP links to Drop down list problems
    By finalmike in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2013, 07:08 PM
  2. HLOOKUP Help
    By Randyexcel in forum Excel General
    Replies: 3
    Last Post: 01-12-2012, 05:05 PM
  3. HLOOKUP in HLOOKUP, Base Estimate Table in Excel
    By gqdallas in forum Excel General
    Replies: 20
    Last Post: 10-19-2009, 01:41 PM
  4. hlookup #N/A
    By stacyjhaskins in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1