Extracting data based on the 3rd digit of the account number

[kenaonoa]

Hello all,

I am trying to pull data from a trial balance report based on the 1st and 3rd digit of the account number to a new worksheet. The account number is in column (A) and I am looking to pull the account number (A), account description(B) & ending balance(E) to the new worksheet. I have used the VLOOKUP function to pull date to a new worksheet based on the account number but have not been able to figure out how to recognize the account number criteria and pull the account number and the subsequent information.

I would be able to truncate the TB report and would only need to use the 3rd digit if using both the 1st and 3rd digits is not possible.

Thank you for all your help,

Keano Noa

 

[akmatz]

Can you post some sample data?

 

[kenaonoa]

[TABLE="width: 865"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]86122[/TD]
[TD]SUPERVISOR COMP-NEW[/TD]
[TD] 215,961.65[/TD]
[TD] 20,519.16[/TD]
[TD] [/TD]
[TD][/TD]
[TD] 236,480.81[/TD]
[/TR]
[TR]
[TD]86123[/TD]
[TD]CLERICAL SAL+WAGES-NEW[/TD]
[TD] 84,999.95[/TD]
[TD] 7,806.37[/TD]
[TD] [/TD]
[TD][/TD]
[TD] 92,806.32[/TD]
[/TR]
[TR]
[TD]86124[/TD]
[TD]OTHER SAL+WAGES-NEW[/TD]
[TD] 34,072.66[/TD]
[TD] 6,707.44[/TD]
[TD] [/TD]
[TD][/TD]
[TD] 40,780.10[/TD]
[/TR]
[TR]
[TD]86125[/TD]
[TD]SPECIALIST COMP-NEW[/TD]
[TD] 80,828.77[/TD]
[TD] 12,359.07[/TD]
[TD] [/TD]
[TD][/TD]
[TD] 93,187.84[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]86132[/TD]
[TD]PAYROLL TAXES-NEW[/TD]
[TD] 119,855.35[/TD]
[TD] 9,086.44[/TD]
[TD] [/TD]
[TD][/TD]
[TD] 128,941.79[/TD]
[/TR]
[TR]
[TD]86133[/TD]
[TD]PENSION EXP-NEW[/TD]
[TD][/TD]
[TD] - [/TD]
[TD][/TD]
[TD][/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]86139[/TD]
[TD]OTHER EMPL BENEFITS-NEW[/TD]
[TD] 42,831.19[/TD]
[TD] 5,593.47[/TD]
[TD] [/TD]
[TD][/TD]
[TD] 48,424.66[/TD]
[/TR]
[TR]
[TD]86142[/TD]
[TD]SUPP/SMALL TOOLS-NEW[/TD]
[TD] 17,906.21[/TD]
[TD] 4,218.58[/TD]
[TD] [/TD]
[TD][/TD]
[TD] 22,124.79[/TD]
[/TR]
</tbody>[/TABLE]

Does this help?

Thanks Again