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.
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 |