Using a VLOOKUP function With a workbook and multiple sheets, Google Sheets keep responding with an “#N/A”, even though I am using a valid VLOOKUP.

The source sheet (Sheet1) is dynamically driven (synced to a WordPress plugin that posts the data dynamically when someone sends a form). The target sheet (Grade 4) is where the formula resides but isn’t working.

WHAT IS SUPPOSED TO HAPPEN:
“Grade 4” sheet is supposed to populate with data based upon the reference number in B1. That number is searched in “Sheet 1” data range A2:I9 and should return the value from “Sheet 1” column 1. It does not.

I have checked the following:

• the data is correct
• the reference is correct
• the data range is fine
• the CELL format matches between the reference and the requested index value in the data range (doesn’t matter if I use the “TEXT” function within my VLOOKUP–same result).
• there are no excess spaces in the cells

Thank you for the help!