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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|