vlookup

[Guest]

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?

 

[Guest]

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)

 

[Guest]

Thanks Paul I was almost right

I was missing the & symbol, doh

 

[Guest]

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

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

 

[comotoman]

this should help,

=if(iserror(your_formula)," ",your_formula)

 

[Guest]

Did the job nicely, ty much

 

[Guest]

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)