Advanced Excel Practice exam 3, Q2

in Advanced Microsoft Excel / Excel Tips & Tricks Part 4

Hi team,

In Q2 the official answer is Index, Match, Match. I think this is a mistake, I can fill the table with only Index Match. Could you please provide the workings for this answer?

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Bunyodbek Mamatkulov

excel is requiring for a password

Temitope Olawunmi

Resolved: Practical case study for excel interview

Collins Roman

Resolved: Advanced excel functions- indirect function

Ahmed Mostafa

exam not found to retake

Mohamed Gamal

error in opening my first exam

Alvin Tan

Excel on a Mac does not have this function

Nunno Nugroho

Resolved: Import Range function in Excel?

Panagiotis Blatsas

Resolved: Is it better practice to lock our excel documents that we send to the company through the protect?