I UPLOADED A FILE WHERE THERE ARE 2 SHEETS:SHEET 1 I EDIT ANYTHING I WANT AND IN SHEET 2 I ACCESS THEM. IN SHEET 2 THERE IS "ENTER ID HERE".WHAT I WANT TO DO IS TO ENTER THE ID OF THE STUDENT AND ALL THE OTHERS(NAME,EXAM 1,2, FINAL EXAM, ATTENDANCE,PROJECT,GRADE,LETTER,CONCLUSION) WILL APPEAR AS SOON I ENTER THE ID.HOW TO DO IT USING BOTH INDEX-MATCH FORMULA AND VLOOKUP: THANK YOU
Solved by I. U. in 19 mins