If cell contains number 1-999 then match with next worksheet and enter name

Hi, I having a problem finding the right formula for this.

I have a column with engineer numbers & I want the next column to show the matching name. The names for the engineers are on the next worksheets. The engineer numbers range from 1 to 999 & on the next worksheet the are listed in numerical order - column A contains numbers & column contains the name.

I think I need something like:-

If cells O7:O34 contain numbers 1 to 999 then equals name of engineer from worksheet 2

Hope you can help.