Asked by:
VLOOKUP function including the link in the to be copied cell
Question

All replies

Are you trying to perform an arithmetic operation on the value in the cell and the value returned by VLOOKUP? If so, and using addition as an example, let the current contents of the cell be expressed as formulla_1: change the contents to be formula_1 + vlookup(value,array,index,match). If necessary, value could also be a repeat of formula_1.
If you are trying to concatenate text, change the cell contents to formula_1 & vlookup(...).

Let's say your want to look for the content of A1 in the cells A2 to A100. If what you look for is found, you want to show what you were looking for and what is the correponding B column cell. In that case, I would go for the formula
=CONCAT(A1,VLOOKUP(A1,A2:E100, 2, TRUE))
Note: Make sure the table is ordered on the A column before you use the formula. Using TRUE on the last parameter will mean it is an approximate match (if you want an exact one, go for FALSE)
Thanks,
Ana
Technical Advisor  Connecting Software  https://www.connectingsoftware.com/blog/
If this post answers the question, please click "Mark as answer"/"Propose as answer" on the post and "Mark as helpful"

Are you trying to extract the URL from a hyperlink in Excel?
If yes,
 Open up a new workbook.
 Get into VBA (Press Alt+F11)
 Insert a new module (Insert > Module)
 Copy and Paste the Excel user defined function below
 Press F5 and click “Run”
 Get out of VBA (Press Alt+Q)
Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End SubThis will separate all the URLs from the hyperlinks in the adjacent cell.