MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 334
- Office Version
- 2013
- Platform
- Windows
The workbook I am referring to in this thread contains several sheets. One sheet for each month of the year and an additional sheet that is called DataSort. This DataSort sheet collects all data from the other 12 monthly sheets and arranges it in chronological order based on the date of the email message referenced. Each entry in each month sheet contains a hyperlink to a specific place in a word document.
So for example, cell B4 in sheet 20FdMay contains text 20Fd05-1 that includes the hyperlink to the word doc as seen here in this image.
Then in the DataSort sheet, cell C276 gets the value from cell B4 in sheet 20FdMay using this formula: =IF(OR(ISBLANK('20FdMay'!$A4)),"",VLOOKUP('20FdMay'!$A4,FdMayData,2,FALSE))
So what I have tried is adding the =HYPERLINK('20FdMay'!B4) to the formula =IF(OR(ISBLANK('20FdMay'!$A4)),"",VLOOKUP('20FdMay'!$A4,FdMayData,2,FALSE)) and it just refuses to work and in addition adds extra text to the cell. This is the full formula I tried: =HYPERLINK('20FdMay'!B4)&IF(OR(ISBLANK('20FdMay'!$A4)),"",VLOOKUP('20FdMay'!$A4,FdMayData,2,FALSE))
Here is the image that shows this result:
First I tried in an empty cell on the DataSort sheet this formula: =HYPERLINK('20FdMay'!B4), but it returns an error as seen here:
So the =HYPERLINK('20FdMay'!B4) formula does not get the hyperlink from cell B4 in the 20FdMay sheet which does work in that B4 cell, but not here in this cell C306 as seen in this third image.
What am I missing?
Thanks for any help offered.
So for example, cell B4 in sheet 20FdMay contains text 20Fd05-1 that includes the hyperlink to the word doc as seen here in this image.
Then in the DataSort sheet, cell C276 gets the value from cell B4 in sheet 20FdMay using this formula: =IF(OR(ISBLANK('20FdMay'!$A4)),"",VLOOKUP('20FdMay'!$A4,FdMayData,2,FALSE))
So what I have tried is adding the =HYPERLINK('20FdMay'!B4) to the formula =IF(OR(ISBLANK('20FdMay'!$A4)),"",VLOOKUP('20FdMay'!$A4,FdMayData,2,FALSE)) and it just refuses to work and in addition adds extra text to the cell. This is the full formula I tried: =HYPERLINK('20FdMay'!B4)&IF(OR(ISBLANK('20FdMay'!$A4)),"",VLOOKUP('20FdMay'!$A4,FdMayData,2,FALSE))
Here is the image that shows this result:
First I tried in an empty cell on the DataSort sheet this formula: =HYPERLINK('20FdMay'!B4), but it returns an error as seen here:
So the =HYPERLINK('20FdMay'!B4) formula does not get the hyperlink from cell B4 in the 20FdMay sheet which does work in that B4 cell, but not here in this cell C306 as seen in this third image.
What am I missing?
Thanks for any help offered.
Last edited: