| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP referencing a cell with a URL
I am using VLOOKUP to reference a cell on another worksheet. The contents of
that cell is a hyperlinked URL. I would like to have the hyperlinked URL show up, but the VLOOKUP function returns only the text. How can I modify the VLOOKUP command to return the hyperlinked URL. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP referencing a cell with a URL
Instead of =VLOOKUP()
use =HYPERLINK(VLOOKUP()) -- Gary''s Student - gsnu200740 "corlev" wrote: I am using VLOOKUP to reference a cell on another worksheet. The contents of that cell is a hyperlinked URL. I would like to have the hyperlinked URL show up, but the VLOOKUP function returns only the text. How can I modify the VLOOKUP command to return the hyperlinked URL. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross referencing with VLookup ? | Excel Worksheet Functions | |||
| Variable in VLOOKUP and referencing a cell another file in excel | Excel Worksheet Functions | |||
| Using vlookup when referencing text | Excel Discussion (Misc queries) | |||
| Vlookup? Referencing cells? | Excel Worksheet Functions | |||
| VLOOKUP referencing another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
