There is probably a very simple answer to this problem ,but I have not been able to find anything in the HELP files I have for Excel which moves me towards a resolution.
Basically I am using a LOOKUP function to connect the full address and event details (stored in Table 2) to a date and location name (stored in Table 1). By using LOOKUP to identify the location name in Table 2 I can bring all of the details across that I require, EXCEPT the hyperlink associated with the postcode. (The hyperlink stores a web address for the location which enables a map to be located and displayed.) Using LOOKUP only brings across the text stored in the relevant cell, and doesn't include the hyperlink.
I really wanted to keep this simple. Is there something else that should be included in the LOOKUP formula to enable the complete contents of the cell to be copied automatically without delving into macros? An example formula is given below:
=IF($C985="","",IF(LOOKUP($C985,Town,Postcode)="","",LOOKUP($C985,Town,Postcode)))
Any guidance here would be much appreciated.
Many thanks
John R
Basically I am using a LOOKUP function to connect the full address and event details (stored in Table 2) to a date and location name (stored in Table 1). By using LOOKUP to identify the location name in Table 2 I can bring all of the details across that I require, EXCEPT the hyperlink associated with the postcode. (The hyperlink stores a web address for the location which enables a map to be located and displayed.) Using LOOKUP only brings across the text stored in the relevant cell, and doesn't include the hyperlink.
I really wanted to keep this simple. Is there something else that should be included in the LOOKUP formula to enable the complete contents of the cell to be copied automatically without delving into macros? An example formula is given below:
=IF($C985="","",IF(LOOKUP($C985,Town,Postcode)="","",LOOKUP($C985,Town,Postcode)))
Any guidance here would be much appreciated.
Many thanks
John R