LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LOU LOU is offline
external usenet poster
 
Posts: 40
Default Vlookup or HLookup or Sumproduct Help

Good Day I have the following information and and am not sure wg=hich is the
best way to handle it.

Sheet1
Row ColumnA ColumnB ColumnC ColumnD
1 Date Audit Auditor Length
2 1/1/07 Butter Frank 1.5
3 1/1/07 Cheese Mary 2.8
4 1/1/07 Meat Perry 3.5
5 1/2/07 Butter Mary 1.5
3 1/2/07 Cheese Frank 2.8
4 1/2/07 Meat Perry 3.5
so on and so forth for the week.

I have on Sheet2 the schedule layed out like the following,

Row ColumnA ColumnB ColumnC ColumnD ColumnE
1 Frank Mary Perry TotalHours


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup or Hlookup Uses for my 2 workbooks Balkar Kalsi Excel Worksheet Functions 1 October 7th 06 12:47 PM
Can you link HLOOKUP AND VLOOKUP formulas and return their interce j.e.med Excel Worksheet Functions 2 August 24th 06 06:55 PM
do i use vlookup or sumproduct??? Lazclark Excel Discussion (Misc queries) 3 June 28th 06 10:23 AM
Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help! Neil M Excel Worksheet Functions 2 December 12th 05 04:31 AM
formula using both vlookup & hlookup xFreeAdvice Excel Worksheet Functions 2 November 17th 04 11:19 PM


All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"