vlookup

A

AWS

In one cell i have a code(eg DRSHITW) 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 DRSHITW_home, DRSHITW_photo etc.

DRSHITW Photo Gallery DRSHITW_photo.

Is there a way of using vlookup for this?
 
P

paul

sure...
your formula would look something like this
assuming the return cell for your dropdown code list is A1 and your webpage
name is shown in B1, your table is A3:B5 ,in C1 type
=A1&vlookup(B1,A3:B5,2,false)
 
A

AWS

It works a treat..........BUT

Would you know how to make it not show #N/A when one of the cells is blank?
 
A

AZExcelNewbie

When using your suggestion Excel doesn't like the " " and will not allow it
in the formula. Here is my formula:
=IF(ISERROR(VLOOKUP($A6,'Sept 9'!$A$1:$U$47,14,FALSE),"",VLOOKUP($A6,'Sept
9'!$A$1:$U$47,14,FALSE)
 
Top