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 Clearly, you are working on an assignment, an Excel proficiency test or some kind of exam that is giving you points per task. Yesterday, 6 points for COUNTIF and SUMIF and one of the members here did the work for you. Today, 6 points for INDEX and MATCH. May I suggest that you work this out on your own by looking in the MS support documentation and/or other on-line resources.
- Riny_van_Eekelen, actually, i am doing a job. its not assignment purpose. I am learning from YouTube, where i found a link for practice. Yesterday, one of the members suggested, COUNTIF but that doesn't work. As i am using MS-EXCEL 13 version, cant using the FILTER and SORT options too. You can check my previous posts also.
