Excel 03 VLOOKUP hyperlink referencing

B

Brackes

Hi all,

In excel 03 I am using VLOOKUP to reverence a row (by the leading cell’s
text) from one worksheet to a larger all inclusive worksheet within the same
workbook.

The larger worksheet is being populated very well but I am not sure how to
get a cell’s hyperlink info to be referenced from the smaller to the larger
worksheet.

Is it possible to have the hyperlink information transferred using VLOOKUP?
I tried paste special > formats but that just brings in the fonts, colors,
ect.

Here is the formula I am using. If possible do I just need to include
something here?
=VLOOKUP($A16,'Greg only'!$A$3:$AE$120,E$1,FALSE)

Thanks for any help
Take care
 
B

Brackes

sorry, i am now getting results in the search criteria.

how might i delet a post?
thanks
 
P

Pete_UK

You can't - it's here forever !!

But thanks for letting everyone know that you no longer have a
problem.

Pete
 
B

Brackes

well, i spoke (wrote) to soon. seems like i still have a problem.

in previous posts i found a possible solution by using the =hyperlink, in
front of my vlookup formula.

This does not seem to work completely for me because it just turns all
visible text into a hyperlink with a path to itself (appeared name). The
cells I am wanting to reference are such that the word in the cell is not a
path, but has a path associated with its actual value.

Is there a way to reference the associated hyperlink of each cell to the new
worksheet?

Thanks again
 
P

Pete_UK

Well I'm sure there is, if I understood your problem a bit better.

Could you describe it again and use examples of what you really have
and what you want to achieve. Please refer to the actual cells and
sheet names in your workbook.

Pete
 
B

Brackes

Pete,

I have a worksheet that contains street intersections and other important
information about them. Column “A†has the intersections unique identifier
number and “E†is the common name for each intersection. Each cell of “Eâ€
also has an associated hyperlink path to a .pdf file on our network that has
pictures, plans, ect. This hyperlink is hidden though and can only be seen
when holding the cursor over the cell.

There are a few hundred intersections controlled by 5 engineers. What I
want to do is take each engineers worksheet of intersections and populate a
master list of all intersections on one worksheet so everyone can see the
information and fallow the hyperlinks.

A majority of the information in each engineers worksheet is updated/changed
often so its important that a continuous referencing or updating to the
master sheet occurs. Secondary need is to have each engineers worksheet
(tab) protected that only they can edit it.


I am using a ‘Vlookup’ formula to reference each engineers information to a
master sheet, but I cant get the imbedded hyperlinks of column “E†to
reference. They just appear as simple text. ‘Vlookup’ is looking for the
unique identifier number of each intersection is column “A†of an engineers
tab, “Greg only†and then populates the main sheet with each found row.
=VLOOKUP($A12,'Greg only'!$A$3:$AE$120,E$1,FALSE)

I can use =Hyperlink(*above formula*) but all this does is turns every cell
into a visible hyperlink with a path of its own cell text.


At this time I do not care if all sheets are in the same workbook. They can
all be separate or together. I figured all sheets could be in the same
workbook, that way anyone wanting to see the master list could also just view
by particular engineer.


Hope this is clear. Thanks again for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top