column and row intersections

[drubin25]

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.

 

[mikerickson]

Perhaps =INDEX(B3:AE15, MATCH("Bob",A3:A15,0), MATCH("2-Sep-20",B2:AE2,0)

 

[drubin25]

Thank you. I used the following based on what you provided and it seems to have worked.

=IFERROR(INDEX(Sheet1!$B$3:$AE$15,MATCH('Total Completions_Monthly'!$A4,Sheet1!$A$3:$A$15,0),MATCH('Total Completions_Monthly'!B$3,Sheet1!$B$2:$AE$2)),0)