have a spreadsheet with a DB file (sheet) named "Students". On it is a list of student ID#, Lname, FName and Grade. I also have a second (sheet) named "Skipped", where I want to input the student ID#,manually and have the computer do the look up of the student name and grade and input those values from the "Students" sheet into the proper fields on the "Skipped" sheet.

I am attaching a short sample of each sheet, along with formula I have been trying to use to get the look up of the name portion. Once I have the name lookup portion figured out, I should be able to get the grade part to work as well. If anyone can help me FIGURE out what my formula should be, I would appreciate it. Thank you.

Here is the formula that I have used but it does not work.

IF(ISNUMBER(MATCH($B2,Students!C1,0)),INDEX(Students!C2,MATCH($B2,Students!C1,0)),"not found")



[recovering DISK space, attachment deleted by admin]Are you trying to populate one sheet with DATA from other sheet or what you pretend to do?
Thanks for your reply. Yes, the one sheet of the workbook "Students" I want to populate on the sheet "Skipped". When we enter the Student ID # on the "Skipped" sheet, I want it to search the "Students" column (where the last name, first name has been combined TOGETHER) and populate the student name into the student name column on the "Skipped" sheet. Thanks for any help you can give me.