1
I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type.
Here are some examples of the database:
Identification Key: ID000012 DESCRIPTION: DO this here in terms of company policy.
Another example:
Identification version 5.1.1 Audit ID: 11123
Last example:
ID: A-12345 Description: DeltaDelta - Download ASAP
See how the IDs all differ just slightly but I'm wanting to pull basically the same information out of each. Is there a formula that can be written to encompass finding "ID000012", "11123" and "A-12345" all these in one?
These are just variables, there are thousands of IDs that I need to pull but I figured giving real life examples would make it easier to see what I'm trying to do here.
1What type of database is this, an Excel workbook or a true database file (access, sql, etc.)? What have you tried so far? – CharlieRB – 2012-12-20T20:46:12.053