IS there a way to creat hyperlinks with a vlookup

[Nikkiho]

Hi, Not sure if this is possible but I have a worksheet that is setup as follows

Sheet 1

Column A Column B
NAME Phone Issued

John 101
Mary 302
Susie 906


Sheet 2

Column A Column B
PHONE NAME NUMBER

101 800-555-7865
302 321-555-9854
906 212-555-6643

What I am looking to do is have it set up so that on Sheet 1 when we put the phone name into the phone issued column the name becomes a hyperlink to the corresponding phone number on sheet 2. This way our mobile device users who will be viewing sheet 1 through Microsoft Teams can click on the phone name and call that number without having to store all 300 phones in their contacts.

Is this possible?

Thanks

 

[jasonb75]

Perhaps something like this?

Book2
	A	B	C
1	name	issued	Number
2	john	101	800-555-7865
3	mary	302	321-555-9854
4	susie	906	212-555-6643
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=HYPERLINK(VLOOKUP(B2,Sheet2!$A$2:$B$4,2,0))

To apply the link to existing text or that entered by the user would only be possible on a desktop version of excel, not on a mobile device.