| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Unique Reference from 2 cells
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a reference from one cell to several other relavent cells | Excel Discussion (Misc queries) | |||
| SUM by unique reference | Excel Worksheet Functions | |||
| Creating A Unique List of Values From A Table | Excel Worksheet Functions | |||
| How do I create a unique spreadsheet reference? | Excel Worksheet Functions | |||
| Any Way of Creating a 'Unique Key'? | New Users to Excel | |||
Threaded Mode
