Ok, here is probably a very simple question but I just can't figure it out. Here is what I have.
2 worksheets
- Worksheet 2 is a query from another database which contains several columns (date, name, total hours and a few others).
- Worksheet 1 is basically a time sheet for the week.
I need the cell in Worksheet 1 which corresponds with a date in Worksheet 2, also to match the name of persons timesheet, to input data from another column of the matched criteria into cell on Worksheet 1.
Simply put - Cell in Worksheet 1 - If (date in Worksheet 1, C3 = date in Worksheet 2, column A) and (name in Worksheet 1, A2 = name in Worksheet 2, column B) then put column E's data into cell on Worksheet 1.
I feel this may include a vlookup & if statement combo or possibly a match in there somewhere. I just don't know where to begin. I have even tried to write some VBA code behide the cell but had no luchk. Please help. Thanks.
Bookmarks