Home |
Search |
Today's Posts |
#1
|
|||
|
|||
data validation using wildcards??
I have a need to cross reference and validate a listing of GL account codes
(12 numeric digits) with an "account filter" table that is formatted with wild cards and bring back one of the fields in the account filter table. The original data table can be '000s of rows so I would like to find a way to automate this as much as possible. Here some sample data: Raw data table: ACCT 731013000804 731510000901 731511000301 731511000340 731511000806 731513000801 For each of these account codes (and thousands more), I would like to cross reference against an account filter table to determine status of account and if code "optional" or "required". Sample of Account Filter table where "_" underscores indicate wild card characters (note, I could easily use another character for the wildcards, the underscore is what comes out of our accounting system). ACCOUNT FILTER STATUS 7310_____8__ OPTIONAL 7315_____8__ REQUIRED 7315100009__ OPTIONAL 731511000340 REQUIRED If there is no match in the listing, then I would like to keep my status blank. I hope this is enough information for someone to point me in the right direction. Thanks in advance for your help. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation | Excel Discussion (Misc queries) | |||
Data validation | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Data Validation | Excel Worksheet Functions |