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))
