Thank you for your reply. But this formula is still resulting in an amount being shown in Column C, even when that account number is present on the list of accounts to exclude.
Quote:
Originally Posted by Mazzaropi
-------------------------------------------------------------------------
Dear Iyanna, Good Afternoon.
Your explanation was very well.
This a typical case to use the VLOOKUP FUNCTION.
Your Scenery:
___A____________B__________C__________D_E_F
1__Account Num__$ Amount___$ Amount 2_________Account to be Excluded
2_______1__________10______=FORMULA__________2
3_______2__________33______=FORMULA__________4
4_______3___________5______=FORMULA__________5
5_______4__________89______=FORMULA__________8
6_______5_________150______=FORMULA
7_______6__________16______=FORMULA
8_______7_________865______=FORMULA
9_______8__________67______=FORMULA
10______9__________44______=FORMULA
FORMULA:
C2 -- =IF(ISERROR(VLOOKUP(A2,$F$2:$F$10,1,FALSE)),B2,"DE LETE")
Copy it down untill C10
The results must be like these ones:
___A____________B__________C__________D_E_F
1__Account Num__$ Amount___$ Amount 2_________Account to be Excluded
2_______1__________10_________10_______________2
3_______2__________33________DELETE____________4
4_______3___________5__________5_______________5
5_______4__________89________DELETE____________8
6_______5_________150________DELETE
7_______6__________16_________16
8_______7_________865________DELETE
9_______8__________67_________67
10______9__________44_________44
You must adapt the contents of column C, eg. BLANK
You must adapt the interval of column F as your reality.
In this case the search works at F2:F10 but your necessity can be F2:F1450
Implement this one and tell me if it worked for you.
Fell free to ask anything about it.
|