I need help formatting an excel document using VLOOKUP

Job ID: 36285853

Budget: $10 – $30 USD

I need it to where when someone inputs an item number, the corresponding product number will auto-populate
Related categories: Visual Basic Data Processing Data Entry Excel