Create hyperlinks using VLOOKUP?

[lunker55]

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

 

[Frank Kabel]

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

 

[lunker55]

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]

Hi
yes, use the second parameter of the HYPERLINK function. e.g.
=HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) &
".jpg","Layout")

 

[lunker55]

Thanks Frank.
Perfect!
Joe

Hi
yes, use the second parameter of the HYPERLINK function. e.g.
=HYPERLINK("C:\temp\" & VLOOKUP(A1,'lookuptable'!A1:B100,2,0) &
".jpg","Layout")