AWS

Posts: n/a

vlookup hyperlink

I have a formula:-

=IF(ISERROR(VLOOKUP(H62,DCRnames,3,FALSE)&F62),"
",VLOOKUP(H62,DCRnames,3,FALSE)&F62)

The result ends up with a web page url, is it possible to make the result a
clickable hyperlink?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP Limitations	chris_manning	Excel Worksheet Functions	2	August 9th 05 06:23 PM
Importing Data from an Access Database Including a Hyperlink Colum	B.C.Lioness	Excel Discussion (Misc queries)	0	May 16th 05 05:26 PM
DropDown with VLOOKUP & HYPERLINK	thom hoyle	Excel Worksheet Functions	1	January 29th 05 05:06 AM
vlookup data hidden within worksheet		Excel Worksheet Functions	0	January 26th 05 12:09 PM
carrying a hyper link when using the vlookup function	mike	Excel Worksheet Functions	1	November 19th 04 03:49 AM

All times are GMT +1. The time now is 07:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us