Vlookup within a range of values

I would like to Look up the number below in sheet2, to determine what range the number is contained within from sheet1, and add the resultant code to sheet2. Can this be done using the Vlookup formula or is there a better way




Sheet1

Start End Code
1200000 1200999 BBHB
1202000 1202999 BBHB
1204000 1204999 BBHB
2320000 2320999 CRAB
2322000 2323999 CRAB
2324000 2324999 CRAB
2334000 2334999 DBNB
2370000 2370999 DBNB
2375000 2375999 DBNB
2376000 2376999 CGAB

Sheet2

Number Result
1202678 BBHB
1204123 BBHB
2321678 CRAB