Index/Match lookup with two columns - Runtime Type 13 Error

Originally Posted by connor12

Thank you very much, it worked!

Any idea why a Match/Index function wouldn't work though?

I'm just curious.

Thanks again!

Connor

You're welcome.

This doesn't concatenate the two columns.
Worksheets("PunchInTimes").Range("A2:A10000") & Worksheets("PunchInTimes").Range("C2:C10000")