In one cell i have a code(eg DR****W) you can select from a drop down list
In another cell I have a webpage name(eg home, photo gallery etc). each
webpage has a code (home = _home, photo gallery = _photo etc) which is in a
list

Home _home
Photo Gallery _photo
Accomodation _accom

I would like to have a cell import the code and a related code to the page
name
together to show DR****W_home, DR****W_photo etc.

DR****W Photo Gallery DR****W_photo.

Is there a way of using vlookup for this?