In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?

Question

Here is a screenshot of the problem despite fixing the column with the $ sign:

Answer 1

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.

Answer 2

So for the Partner company column you would have this formula =INDEX(Data!$C:$C,MATCH(Output!B3,Data!$E:$E,0))

In essence, the formula performs the following actions:

Searches for the value in cell B3 of the "Output" sheet within column E of the "Data" sheet, e.g., both Code colums.
Finds the row where that "Code" value exists in the "Data" sheet.
Retrieves the corresponding value from the same row in column C of the "Data" sheet, e.g., partner company.

In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?

Submit an answer

related questions