|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 14th, 2004, 09:33 PM
|
|||
|
|||
Create hyperlinks using VLOOKUP?
I would like to enter a model number(CM3636a) in A1.
When entered, is there a way to lookup in a table and create a hyperlink automatically? I have hundreds of model numbers which I want to associate a diagram(jpg). I only want to do this once, then everytime the same model number is entered, a link is created to that diagram. Can anyone think of any ingenious ideas on how to achieve something like this? Joe 
|
|
#2
June 14th, 2004, 09:34 PM
|
|||
|
|||
|
Create hyperlinks using VLOOKUP?
Hi
if you have the name of a file in column b try something like =HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) & ".jpg") -- Regards Frank Kabel Frankfurt, Germany lunker55 wrote: I would like to enter a model number(CM3636a) in A1. When entered, is there a way to lookup in a table and create a hyperlink automatically? I have hundreds of model numbers which I want to associate a diagram(jpg). I only want to do this once, then everytime the same model number is entered, a link is created to that diagram. Can anyone think of any ingenious ideas on how to achieve something like this? Joe
|
|
#3
June 15th, 2004, 03:39 PM
|
|||
|
|||
|
Create hyperlinks using VLOOKUP?
Thank you Frank.
Works perfectly. I am so happy. Am I able to change the visible text in the hyperlink? Instead of showing the location(very long-server location), can the cell just show "Layout"? Joe "Frank Kabel" wrote in message ... Hi if you have the name of a file in column b try something like =HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) & ".jpg") -- Regards Frank Kabel Frankfurt, Germany lunker55 wrote: I would like to enter a model number(CM3636a) in A1. When entered, is there a way to lookup in a table and create a hyperlink automatically? I have hundreds of model numbers which I want to associate a diagram(jpg). I only want to do this once, then everytime the same model number is entered, a link is created to that diagram. Can anyone think of any ingenious ideas on how to achieve something like this? Joe
|
|
#4
June 15th, 2004, 06:48 PM
|
|||
|
|||
|
Create hyperlinks using VLOOKUP?
Hi
yes, use the second parameter of the HYPERLINK function. e.g. =HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) & ".jpg","Layout") -- Regards Frank Kabel Frankfurt, Germany lunker55 wrote: Thank you Frank. Works perfectly. I am so happy. Am I able to change the visible text in the hyperlink? Instead of showing the location(very long-server location), can the cell just show "Layout"? Joe "Frank Kabel" wrote in message ... Hi if you have the name of a file in column b try something like =HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) & ".jpg") -- Regards Frank Kabel Frankfurt, Germany lunker55 wrote: I would like to enter a model number(CM3636a) in A1. When entered, is there a way to lookup in a table and create a hyperlink automatically? I have hundreds of model numbers which I want to associate a diagram(jpg). I only want to do this once, then everytime the same model number is entered, a link is created to that diagram. Can anyone think of any ingenious ideas on how to achieve something like this? Joe
|
|
#5
June 15th, 2004, 08:36 PM
|
|||
|
|||
|
Create hyperlinks using VLOOKUP?
Thanks Frank.
Perfect! Joe "Frank Kabel" wrote in message ... Hi yes, use the second parameter of the HYPERLINK function. e.g. =HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) & ".jpg","Layout") -- Regards Frank Kabel Frankfurt, Germany lunker55 wrote: Thank you Frank. Works perfectly. I am so happy. Am I able to change the visible text in the hyperlink? Instead of showing the location(very long-server location), can the cell just show "Layout"? Joe "Frank Kabel" wrote in message ... Hi if you have the name of a file in column b try something like =HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) & ".jpg") -- Regards Frank Kabel Frankfurt, Germany lunker55 wrote: I would like to enter a model number(CM3636a) in A1. When entered, is there a way to lookup in a table and create a hyperlink automatically? I have hundreds of model numbers which I want to associate a diagram(jpg). I only want to do this once, then everytime the same model number is entered, a link is created to that diagram. Can anyone think of any ingenious ideas on how to achieve something like this? Joe
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
