This is my second attempt to resolve this issue I am having. My last attempt was abruptly cut short with no notification or resolution. Credits were used but no resolution, guidance or suggestions.
Hello, in the attached spreadsheet, I will be pasting data from a separate source in the "Sheet 2" tab. I need to have the student numbers on "Sheet 2" pull the corresponding student name (first and last), room (column I), Grade Level (column W) and Course (column F) found on "Sheet 1". The results of this search can be displayed on either Sheet 2 or a new sheet (Sheet 3). Also, Sheet 1 has multiple rows associated with a single name. I will need to pull the class connected to "01-01" in Column L (PRDS). I attempted to use the VLOOKUP feature but continued to receive errors. Please help!
Solved by A. Q. in 13 mins