I am trying to create a formula that will return a record number (in column A on "Report" sheet) based on matching both a last name (C4) and date (E4) with a corresponding last name (column AE) and date (column B) on a second sheet ("Report"). This is what I have so far:
=INDEX(Report!$A:$AE,MATCH(C4&E4,Report!$AE:$AE&Report!$B:$B,0),1)
I keep getting a #VALUE error. I don't know what I am doing wrong. Please Help!!
=INDEX(Report!$A:$AE,MATCH(C4&E4,Report!$AE:$AE&Report!$B:$B,0),1)
I keep getting a #VALUE error. I don't know what I am doing wrong. Please Help!!
