gilmoregirlz
New Member
 Joined
 Aug 14, 2021
 Messages
 3
 Office Version

 2010
 Platform

 Windows
I'm trying to add this function into a worksheet that was made by someone else several years ago. I've googled and tried different formulas but I'm not having success. I'm not familar with creating functions at all.
Basically I have a worksheet where I want to be able to type in a student id number and have it pull up the students name. The student numbers and names are stored in a worksheet in a completely different file. I tried to copy one of the existing formulas in the sheet and just changed what seemed to be relevant, but Excel (2010) is saying there is an error with the formula. This is what I'm trying:
=IF(B6="","",IF(ISNA(VLOOKUP(B6,'[Book Inventory saved.xls]Students'!$A:$B,2,0)))
Is there anything in this that immediately jumps out as being wrong? I'm totally lost here and really scrambling to try to get this to work before school starts.
B6 is where I want to type the student number and the student name needs to show up in B7. I'm trying to enter the formula into B7. The student names and numbers are in the "Students" worksheet of the Book Inventory saved.xls file. Numbers are in column A 2<, names are in column B2<.
Any help would be SO very much appreciated!
Basically I have a worksheet where I want to be able to type in a student id number and have it pull up the students name. The student numbers and names are stored in a worksheet in a completely different file. I tried to copy one of the existing formulas in the sheet and just changed what seemed to be relevant, but Excel (2010) is saying there is an error with the formula. This is what I'm trying:
=IF(B6="","",IF(ISNA(VLOOKUP(B6,'[Book Inventory saved.xls]Students'!$A:$B,2,0)))
Is there anything in this that immediately jumps out as being wrong? I'm totally lost here and really scrambling to try to get this to work before school starts.
B6 is where I want to type the student number and the student name needs to show up in B7. I'm trying to enter the formula into B7. The student names and numbers are in the "Students" worksheet of the Book Inventory saved.xls file. Numbers are in column A 2<, names are in column B2<.
Any help would be SO very much appreciated!