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...