return an address from VLOOKUP and hyperlink to cell with original value
A1 has a VLOOKUP that returns a value. I would like A1 to be linked via HYPERLINK (requires an address) to the cell where the value comes from.
the formula I have is...
Ok, I've look thought the net and can't yet find an Answer, I think i'll need a macro to work it where i'm more of a Beginner in VBA,
But what i am trying to do is that In Sheet 1 coloum A I have a list of Hyperlink that go to certain Excel spreadsheets.
With in Sheet 2 I have all the details...
Hi,
I have 2 workbooks in the same file. WKBK1 "main" has 2 columns . col 1 is a list of part numbers and col 2 if the "totalcost" of that part number. WKBK2 has 4 columns, first col is same list of parts and col 4 if the total cost and col 2 and 3 are break up of that cost.
I need to make...
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.