solved... I used another reference cell...
=TEXT(J9,"DD MMMM YYYY")

Which returns (for today) "26 January 2009".
I can then reference this cell elsewhere.

I am trying to keep formatting between cell references.

For instance, I have a date in once cell (J9) and would like to add this date to a text field so e.g.:

="This will take effect on " & J9...

I have this all figured out now.

Okay, I came up the following code which finds the cell address of the lookup (z) data.


Sub lookup()
Dim lookup
lookup = Range("lookup").Value
For each c in Range("lookup_range").Cells
If...

Unfortunately, I don't think this question is solved with a simple vlookup, or etc.

I have a spreadsheet that has several tables of data with the following format on one sheet:

gxxxx
gxxxx...