Last answered:

18 Nov 2023

Posted on:

25 May 2023

0

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)
Posted on:

18 Nov 2023

0

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. 

Submit an answer