| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup, Index, Match, or Sumproduct?
You're welcome!
Biff "Phrank" wrote in message ... Excellent! Thank you very much! On Mon, 12 Feb 2007 23:37:04 -0500, "T. Valko" wrote: You need to use a combination: Vlookup/Match =VLOOKUP(name,lookup_table,MATCH(date,date_range ,0),0) Index/Match/Match =INDEX(lookup_table,MATCH(name,name_range,0),MAT CH(date,date_range,0)) Biff "Phrank" wrote in message . .. Hi, I'm setting up an overtime metrics worksheet. I have two sheets. On one sheet I have all employee names in column A and pay dates in row 1. On Sheet 2, I have the same dates in Row 1, but the names in column A are simply sorted in a different manner (by work group). Weekly overtime hours are entered in sheet 1, and I'd like sheet 2 to simply 'read' the name and date and enter the associated OT hours. Which would I use, Vlookup, Index, Match, Sumproduct, or a combination of some of them? Thanks. Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements? | Excel Worksheet Functions | |||
| maybe lookup/index/match/sumproduct | Excel Discussion (Misc queries) | |||
| Index Match Vlookup? | Excel Discussion (Misc queries) | |||
| Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
| Combine index match and sumproduct | Excel Discussion (Misc queries) | |||
Threaded Mode
