Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match data to find intersection
Can anyone help? In SheetA I have a date in ColA, name in ColB, hours in
ColC. In SheetB I have a table of dates and names. I need to find the intersection in this table of the date and name from SheetA and place the hours in that cell. I have a list of names in SheetA so I need to loop through that checking for an intersection in SheetB of name and date. If there is no intersection (the name doesn't exist in SheetB) I need to add a new row for that name. I've tried using match, intersection, and index but can't seem to get anything to work just right! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find a value at an intersection? | Excel Discussion (Misc queries) | |||
How to find intersection points between lines using Excel? | Excel Programming | |||
I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Worksheet Functions | |||
Find intersection point using lables? | Excel Programming | |||
Find Intersection | Excel Programming |