+ Reply to Thread
Results 1 to 3 of 3

Need help with a Hlookup formula

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    85

    Need help with a Hlookup formula

    Hello Everyone

    I was after some help for a formula im working on for a register but im having a little trouble with putting together a formula. The spreadsheet itself consits of 12 tabs (one for each month) and then one other tab which is a daily summary. On the daily summay I have the following formula in column B :

    =HLOOKUP($C$4,INDIRECT(TEXT($C$4,"mmmm")),3,FALSE)

    which works great and brings back the information im after but it isnt ideal! Instead of using a cell refrence I want to refernce the name of the person so that the formula would look at the date and look at the name and bring back the results. Ive attached an example spreadsheet and how its currently working. Is there way to combine a vlookup with a hlookup? Im at a loss and really need to solve this! Ive attached an example spreadsheet.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Need help with a Hlookup formula

    Hello, try this.

    =HLOOKUP(C$4,INDIRECT(TEXT(C$4,"mmmm")),MATCH(A7,INDEX(INDIRECT(TEXT(C$4,"mmmm")),0,1),0),0)
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    10-03-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    85

    Re: Need help with a Hlookup formula

    Thanks that seems to have worked great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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