Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Need help with HLOOKUP function in excel! Urgently please

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts

Hey Guys,


I run a spreadsheet for my business that has a summary page. This summary page grabs data from other sheets to give me averages etc.


I use the HLOOKUP function to lookup "today's" date minus 2-7 days within another sheets data range and then it gives me a snapshot on the summary page of whats happening.

The problem is that it was working great until we rolled into the new year...... Now it wont recognize any data from 1st Jan on wards. When I change the lookup date to the 31/12/15 it is fine but when the date rolls over the data dissapears!!


Help please??? I'm assuming this could just be a simple formatting fix within Excel?


Many thanks Aaron 

  • 0




    Malware Expert

  • Expert
  • 17,273 posts
  • MVP

Assuming the date actually appears in the first row of the table the usual problem is that the table has outgrown the referenced array.  Then there is the possibility that you are doing something wrong in your minus 2-7 days calculation.  Difficult to say without seeing the actual HLOOKUP function and having a feel for the table.  Are you getting an error or does it just return blanks?


Can you do a test HLOOKUP where you leave off the minus 2-7 stuff?  Does it get data then?

  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP