vlookup
 

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?

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)
--
paul
remove nospam for email addy!



"AWS" wrote:

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?

Thanks Paul I was almost right

I was missing the & symbol, doh

"paul" wrote:

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)
--
paul
remove nospam for email addy!



"AWS" wrote:

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?

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

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


"paul" wrote:

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)
--
paul
remove nospam for email addy!



"AWS" wrote:

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?

this should help,

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


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=468360

Did the job nicely, ty much :)

"comotoman" wrote:


this should help,

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


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=468360

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)

"AWS" wrote:

Did the job nicely, ty much :)

"comotoman" wrote:


this should help,

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


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=468360