Step 08 of 40: MATCH Function

Q. Why is my MATCH function returning #N/A through the entire column?

A. Your issue is in cell M2 of the User List worksheet. Make sure to include a space after the comma that appears inside double-quotes otherwise your MATCH function will not work properly in Step 8 of 40.

The incorrect version of the formula is: =CONCATENATE(C2,",",B2)The correct version of the formula is: =CONCATENATE(C2,", ",B2)

It's very subtle, but the second argument in CONCATENATE is ", "  (comma space) and not "," (comma only). 

Please email support@studentsexcel.com if you have a question that is not covered above.