Make Hyperlink read cell contents

[anoble1]

If I have this hyperlink

Is there a way I can make a column in Excel and 5 rows of part numbers and make the hyperlink read it?
Can I make this hyperlink generate based on the info in my sheet?

Please Login or Register  to view this content.

These are 2 sample part numbers. I can go up to partNo3,4,5
Ideas?

[AliGW]

Yes, but ...

There are instructions at the top of the page explaining how to attach your sample workbook.

[anoble1]

So I got it to work below with this formula. How can I turn it into a hyperlink?

Please Login or Register  to view this content.

When I manually copy it I get this which is correct.

[AliGW]

Did you try:

=HYPERLINK(CONCATENATE(A25,"partNo1=",partNo1,"&","partNo2=",partNo2,,"&","partNo3=",PartNo3,"&","partNo4=",partNo4,"&","partNo5=",partNo5))

[anoble1]

No but didn't work when I just tried it. Value Error

[AliGW]

Try without the double comma after partNo2:

=HYPERLINK(CONCATENATE(A25,"partNo1=",partNo1,"&","partNo2=",partNo2,"&","partNo3=",PartNo3,"&","partNo4=",partNo4,"&","partNo5=",partNo5))

[anoble1]

Good catch. Didn't seem to work still

[AliGW]

OK - well, sorry - without seeing it in situ, there's nothing more I can do.

[anoble1]

See attachment

[AliGW]

There's nothing in A25 in your sample workbook.

[AliGW]

Try this:

=A25&"partNo1="&partNo1&"&partNo2="&partNo2&"&partNo3="&PartNo3&"&partNo4="&partNo4&"&partNo5="&partNo5

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[AliGW]

Nothing - not even a thank you???