hlookup

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi, I am trying to use HLookup and I haven't got this
right yet. I am wanting to add hours from a previous pay
period to the current one. So I need to search my table
based on consecutive dates and pull the hours worked for
those dates.

(Ultimately, I would like to have a begin date and end
date, have the formula find those days hours plus for the
days inbetween.)

Can someone tell me what I might be doing wrong? No
matter what I have done so far, I get #NA.


=HLOOKUP(B52,A8:A14,6,False)

b52=3/15/2004
A8:A14 = the range the dates are in
6= column the hours are in

Hours From Previous Period
Add In Dates Hours Total Hours
3/15/2004
3/16/2004
3/17/2004

Table
Date Hours
3/14/2004 8:00
3/15/2004 10:30
3/16/2004 10:00
3/17/2004 8:00
3/18/2004 8:00
3/19/2004 0:00
3/20/2004 0:00
 
Hi Todd
From your post it appears your data is in columns try
using VLOOKUP.
=VLOOKUP(B52,$A$8:$A14,6,False)
If totals will exceed 24 hrs, format cells custom [h]:mm


HTH
Regards Bob C.
 
Back
Top