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]

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

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Does this help?

Thanks Again