Hyperlink w/ V-lookup to return actual URL Value?

[mrstaggart]

So the webpage is

Http://www.techgoddess.com/importantpage.aspx?ID=XX

where the XX is an ID from a SQL db because the page posts data for a specific record.

Using Vlookup, how do I return the XX into the hyperlink?

If I use the Vlookup, I can't get the quotes and the bracket in the right place to return my ID value. Oh, and I've got the right friendly name (another vlookup) so that part is fine.

thanks,
TechGoddess

 

[cLFlaVA]

Note sure what you're asking. Could you use the Right(string, numChars) function?

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[mrstaggart]

I can't seem to attach another function to the end of the Hyperlink function.
When I use this (E52 is the friendly name):

HYPERLINK("[

http://server16/Report.aspx?FPID=

]VLOOKUP(A49, Sheet2, 2, FALSE)",E52)

I get a link to

Http://server16/report.aspx?fpid=

If I remove the [] it links to the text for vlookup:

Http://server16/report.aspx?fpid=VLOOKUP(A49,

Sheet2, 2, FALSE).

How do I add a function to the hyperlink? I want the value of the vlookup.

TechGoddess

 

[cLFlaVA]

Try this:

(I haven't tested it...)

HYPERLINK(CONCATENATE("

http://server16/Report.aspx?FPID=",

VLOOKUP(A49, Sheet2, 2, FALSE)),E52)

This will concatenate the first part of the URL along with the result of the lookup.

Let me know how it works.

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[bluedragon2]

=HYPERLINK(

http://server16/Report.aspx?FPID=&VLOOKUP(A49,

Sheet2, 2, FALSE)&E52)



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

oops missed the quotes:

=HYPERLINK("

http://server16/Report.aspx?FPID="&VLOOKUP(A49,

Sheet2, 2, FALSE)&E52)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[mrstaggart]

Thank you bluedragon2, but it doesn't respond to the quotes and the ampersand produces an error.

 

[mrstaggart]

Hail TO cLFLaVA!
The concatenation works!
So, now for anyone else that needs this, I have a function that looks like this:
=HYPERLINK(CONCATENATE("

http://server16/Report.aspx?FPID="

& ( VLOOKUP($A57, Sheet2, 8, FALSE))),( VLOOKUP($A57, Sheet2, 2, FALSE)))

Where column 8 = the db ID and column 2 = friendly name "Mike Smith".

Thank you for your time and guidance.

TechGoddess

 

[bluedragon2]

Strange mrstaggart, works great on mine...



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...