In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?
Here is a screenshot of the problem despite fixing the column with the $ sign:
1 answers ( 0 marked as helpful)
You need to fix the lookup value in output sheet of match function, so that when you paste that formula to the right cells, lookup value column should remain same.