I am struggling on this one...
I have names in A4:A15 and dates in B3:AF3 on a tab named "Total Completions_Monthly". Cells B4:AF15 are blank and I want to populate them with values where two criteria are met from the raw data in the Sheet1 tab.
If the name in A4:A15 "Total Completions_Monthly" is found in column A (Sheet1) and if the date in B3:AF3 "Total Completions_Monthly" is found in row 2...I want to find the number where the name and date intersect.
For example:
I want to search for Bob on 2-Sep-20 in Sheet1 A2:AE15 and place the value where the criteria is met on the "Total Completions_Monthly" tab where Bob and 2-Sep-20 meet.
Hopefully I am making sense. Any help is appreciated.
I have names in A4:A15 and dates in B3:AF3 on a tab named "Total Completions_Monthly". Cells B4:AF15 are blank and I want to populate them with values where two criteria are met from the raw data in the Sheet1 tab.
If the name in A4:A15 "Total Completions_Monthly" is found in column A (Sheet1) and if the date in B3:AF3 "Total Completions_Monthly" is found in row 2...I want to find the number where the name and date intersect.
For example:
I want to search for Bob on 2-Sep-20 in Sheet1 A2:AE15 and place the value where the criteria is met on the "Total Completions_Monthly" tab where Bob and 2-Sep-20 meet.
Hopefully I am making sense. Any help is appreciated.