I need to pull data from a 2nd spreadsheet with vlookup where my reference is
not unique (there is a non unique numerical reference and a non unique date
but combined these would be unique). I would like to combine a 3 digit number
and a date to create a unique reference e.g. '100' and '01/07/2008'.
Is it possible to do this?
Or how else can I pull data from one spreadsheet to another when the
numerical references are not unique?