Hyperlink function question

A

atcman

Board Regular
Joined
May 13, 2005
Messages
58
Can a hyperlink on a spread sheet be constructed to lookup last four digits of a US zip code entered in another cell?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
As far as I know Hyperlinks can only link you to places. They cannot perform actions.

If your zip code is Range("A1")
Put this formula in Range("A2")
=(RIGHT(A1,4))
 
Upvote 0
You must log in or register to reply here.

Similar threads

SamarthSalunkhe
  • Solved
Copy Excel From Zip Folder
Replies
9
Views
223
Domenic
D
H
  • Question
Macro to download zip, unpack and copy data
Replies
0
Views
78
HeinrichPaul
H
L
  • Question
VBA to simulate clicking on a cell with LET function which has a HYPERLINK function within
Replies
6
Views
286
Ludwig
L
S
  • Solved
How to remove a character from a string using a formula
Replies
2
Views
486
smalik
S
E
  • Question
Can you do an API call in Excel using VBA?
Replies
2
Views
272
John_w
J

Forum statistics

Threads
1,214,897
Messages
6,122,141
Members
449,066
Latest member
Andyg666

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top