Auto Populate from Source Sheet

[fareedexcel]

Dear Experts,

I tried auto populating the data from the source sheet. I tried with Index and Match Function, but I'm getting an error. Could you please advise why the error occurs and what would be the correct formula.

 

[alacrity59]

If you look at column C you are asking to index 1,2. I.e. row 1 and column 2. The range you are indexing on is only one column wide.

 

[AlanSidman]

try this {=INDEX(Master!$C$2:$C$5731,MATCH(1,($A2=Master!$A$2:$A$5731)*(Answer!B$1=Master!$B$2:$B$5731),0))}

Instead of just using the enter key, you must use Ctl + Shift +Enter

This is an array formula

Array Formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

 

[fareedexcel]

Thanks Alan. Formula is working fine