Forum Discussion
Solved
Index Match From another Sheet
Hello, I have attached a file where I have to bring some cell value from another sheet using Index/Match Function. Can anyone help me regarding this! Thanks in Advance!
najim_uddin Try following formula and drag down and across as needed.
=INDEX(Data!$B:$D,MATCH($B9,Data!$A:$A,0),COLUMN(A$1))
najim_uddin Try following formula and drag down and across as needed.
=INDEX(Data!$B:$D,MATCH($B9,Data!$A:$A,0),COLUMN(A$1))
- Thanks Harun24HR, it works but can you please explain why you added COLUMN(A$1), in the last? I tried several times without COLUMN(A$1).
- I have added COLUMN(A$1) to make column reference dynamic for INDEX() function so that you can just drag the formula for right columns. You can use =INDEX(Data!$B:$B,MATCH($B9,Data!$A:$A,0)) without COLUMN(A$1) but in this case you have to use 3 formula for 3 different column like, =INDEX(Data!$B:$B,MATCH($B9,Data!$A:$A,0)), =INDEX(Data!$C:$C,MATCH($B9,Data!$A:$A,0)), =INDEX(Data!$D:$D,MATCH($B9,Data!$A:$A,0))
- Many thx for posting that. It was a big help!
