Adding information automatically

[bassemjohn1]

hello guys,


is there any way I can add the bank account automatically

For Ex: for TASC >> I use AED-001 account
and for oracle >> I use USD -001

I add them manually each month in column H , so is there any way I can let excel detect if it's oracle supplier for example, then put USD-001 in column H and so on.

AEJ P.P.xls
	A	B	C	D	E	F	G	H	I	J	K	L
1	SupCode	Sup Name	INV Date	Tran No	InvoAmountO	Pay AmountO	Diff	DIV	PGC	BEDATE	CUR	DUEDATE
2	0019	TASC Labour services LLC					13,298.25	AED - 001
3	AED		0.00
4	0019		28-Jun-20		13,298.25	0.00
5	SupCode	Sup Name	INV Date	Tran No	InvoAmountO	Pay AmountO	Diff	DIV	PGC	BEDATE	CUR	DUEDATE
6	0052	Oracle Netsuite					2,267.46	USD - 102
7	USD		0.00
8	0052		18-Feb-20		2,267.46	0.00
9	SupCode	Sup Name	INV Date	Tran No	InvoAmountO	Pay AmountO	Diff	DIV	PGC	BEDATE	CUR	DUEDATE
10	0272	On Time Shipping Services LLC					6,664.00	AED - 002
11	AED		0.00
12	0272		4-Mar-20		1,529.00	0.00
13	0272		2-Mar-20		3,750.00	0.00
14	0272		8-Jul-20		1,385.00	0.00
Sheet1

Cell Formulas
Range	Formula
G2,G10,G6	G2	=SUMIFS(E:E,A:A,A2)-SUMIFS(F:F,A:A,A2)

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Sheet1!$A$1:$L$52	G10, G6, G2