Should be Column A then D then C. You entered C, D, A
CTRL + SHIFT + ENTER
=INDEX(PhysMaster!$A$2:$A$841,MATCH(F9&H9&G9,PhysMaster!$A$2:$A$841&PhysMaster!$D$2:$D$841&PhysMaster!$C$2:$C$841,0))
Should be Column A then D then C. You entered C, D, A
CTRL + SHIFT + ENTER
=INDEX(PhysMaster!$A$2:$A$841,MATCH(F9&H9&G9,PhysMaster!$A$2:$A$841&PhysMaster!$D$2:$D$841&PhysMaster!$C$2:$C$841,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks