Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine v and h lookups
I have the following roster counting the number of hours staff work on a
given day: A B C D 1 Date 1 Date 2 Date 3 2 Name 1 8 6 7 3 Name 2 7 5 7 4 Name 3 6 3 4 In a report in a different workbook I need to have a formula to return the contents of a cell based on both the name and the date: ie: lookup Name 3 and date 3 and return the value of D4. I cannot use column / row numbers as the positions change based on staffing changes. How do I do this please? -- scheduler |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine v and h lookups
=INDEX(A1:D4, MATCH(Name, A1:A4, 0), MATCH(Date, A1:D1, 0))
where Name and Date are cell references containing your criteria. "scheduler" wrote: I have the following roster counting the number of hours staff work on a given day: A B C D 1 Date 1 Date 2 Date 3 2 Name 1 8 6 7 3 Name 2 7 5 7 4 Name 3 6 3 4 In a report in a different workbook I need to have a formula to return the contents of a cell based on both the name and the date: ie: lookup Name 3 and date 3 and return the value of D4. I cannot use column / row numbers as the positions change based on staffing changes. How do I do this please? -- scheduler |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookups or something | Excel Worksheet Functions | |||
need help with V lookups | Excel Worksheet Functions | |||
Lookups | Excel Discussion (Misc queries) | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Lookups | Excel Discussion (Misc queries) |