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:
2 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.
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.