Forcing vlookup to return formula instead of result

USgA0HwU1P

New Member
Joined
Jan 24, 2019
Messages
1
Sheet1 is vendor number and vendor name. Vendor name takes the form of a hyperlink formula that links to their homepage. (i.e. so the text that displays is Microsoft but if you were to actually click it, it takes you to microsoft dot com)

Sheet2 contains the vendor number.

The goal is to do a vlookup that populates sheet2 with the vendor name but retains the hyperlink.

What's the best way to do this? Thanks.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
Ok, so to put things more clearly you want to do a VLOOKUP on a vendor number and pull back the hyperlink text and the actual URL, presumably in separate cells?
Doesn't look like you can get the URL with a formula, only option that comes up on Google is via VBA/UDF.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,952
Messages
5,525,851
Members
409,667
Latest member
jwieting

This Week's Hot Topics

Top