vlookup

[luxbax12]

Hi All,
if acct # in column A matches an account # in column D then i would like for the value in column E to be placed in Column C.If the account number is not listed in column D
then the value in column B would be placed in Column C.
Thanks For any advice.

customer types_060608.xls
	A	B	C	D	E
1	Acct #	Current Amnt	New Amnt	Acct #	Sale Amnt
2	000001119383	0		10000040	570.08
3	1000040	0		000001000918	0.00
4	000001299850	0		000001001418	0.00
5	000001777201	0		000001002511	9374.50
6	000001579306	0		000001002561	0.00
7	000001797416	0		000001005022	361.80
8	000001476010	0		000001008587	272.00
9	000001651819	0		000001014005	17702.40
10	000001767850	0		000001014296	89.00
11	000001113347	0		000001016083	756.50
12	000001025167	0		000001016199	31651.20
13	000001285124	0		000001017400	1026.20
14	000001624316	0		000001017489	0.00
15	000001405206	0		000001017913	4904.30
16	000001741595	0		000001018124	7309.17
17	000001734210	0		000001018213	3654.85
18	000001816723	0		000001018379	0.00
19	000001419042	0		000001018416	0.00
20	000001099384	0		000001019031	1456.20
21	000001753819	0		000001019072	301.00
22	000001417559	0		000001019252	7911.50
23	000001516124	0		000001021582	4540.48
24	000001268610	0		000001022036	36270.00
25	000001571222	0		000001024302	797.40
26	000001851508	0		000001029789	9386.30
27	000001267904	0		000001030469	40171.95
28	000001883557	0		000001034151	803.50
29	000001016350	0		000001034359	136.50
30	000001720333	0		000001035793	152.50
Sheet1

 

[luxbax12]

Hey Aladin,
Ok that formula gave me the correct amount for the first account in column A,
But when i dragged down, it gave me a zero for the account 1000040, which should have been $570.08.

Thanks for helping.

Book1
	A	B	C	D	E
2	1119383		1000	10000040	570.08
3	1000040		0	1000918	0.00
4	1299850		0	1001418	0.00
5	1777201		0	1002511	9374.50
6	1579306		0	1002561	0.00
7	1797416		0	1005022	361.80
8	1476010		0	1008587	272.00
9	1651819		0	1014005	17702.40
10	1767850		0	1014296	89.00
11	1113347		0	1016083	756.50
12	1025167		0	1016199	31651.20
13	1285124		0	1017400	1026.20
14	1624316		0	1017489	0.00
Sheet1

 

[Aladin Akyurek]

1000040 is not the same as 10000040. The latter has an additional 0 between digit 1 and digit 4...

 

[luxbax12]

Aladin,
Thanks for your help and Patience.
I have it working now.