Linking a persons name with their staff number, VLOOKUP only gives the last name in table array.

Currently trying to automate part of my aircraft maintenance logbook, which needs me to fill out a form, and get it signed by the relevant engineer.

I have an excel sheet of all of my work experience, including the jobs I have done, which has been downloaded from the employers website. However, for the engineer field, it only gives a staff number, with the format S111111. On a second sheet, I have a list of the engineers and their staff numbers, however, they are only a numerical format, 111111.

The work experience spreadsheet is a downloaded version from our online system, but with an extra column added to the right so that the engineers name can be auto populated as and when new jobs are added to the spreadsheet.

The table with the engineers name and staff number is from another excel file, sorted lowest to higher by staff number, and then copy and pasted to the engineer list sheet on the main excel file.

I have tried a VLOOKUP, however it will only return the final name in the list. The exact formula I have used is below.

=VLOOKUP(H25,'Engineers List'!$B$3:$G$70,3,TRUE)

The formula is going in to cell BC2, H25 is the cell with the engineers staff number, 'engineer list' is the sheet with the list of engineers staff numbers (column 2) and names (column 3). True returns the final name in the list, Mr Z for example, but if I change TRUE to FALSE, I only get #N/A as a result.

I do not have access to Office 65 on my PC, so XLOOKUP is not available to me. Cells are both formatted as general. I Have tried to remove the S from the staff number and formatting both as numbers, but it returned N/A. I also tried the other way and added an S to the staff number list, but still got N/A.