IF function to define and track expense types

%3CLINGO-SUB%20id%3D%22lingo-sub-1621662%22%20slang%3D%22en-US%22%3EIF%20function%20to%20define%20and%20track%20expense%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621662%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20set%20up%20the%20%3CSTRONG%3EIF%3C%2FSTRONG%3E%20function%20to%20track%20expenses%20on%20a%20downloaded%20csv%20statement%3F%20I%20want%20the%20function%20to%20search%20cells%20in%20one%20column%20for%20specific%20words%2Fstore%20names%2C%20and%20then%20classify%20it%20by%20the%20expense%20type%20I%20specify.%20example%2C%20cell%20in%20column%20B%20shows%20%22Mobil%22%2C%20I%20want%20adjacent%20cell%20in%20column%20C%20to%20automatically%20generate%20%22gas%2Ffuel%22%2C%20cell%20in%20column%20B%20shows%20%22grocery%20store%22%20I%20want%20adjacent%20cell%20in%20column%20C%20to%20automatically%20generate%20%22food%22.%20Is%20this%20possible%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1621662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1621824%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%20to%20define%20and%20track%20expense%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776182%22%20target%3D%22_blank%22%3E%40mdion1819%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20suggest%20to%20use%20PivotTable%20on%20imported%20from%20csv%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Is it possible to set up the IF function to track expenses on a downloaded csv statement? I want the function to search cells in one column for specific words/store names, and then classify it by the expense type I specify. example, cell in column B shows "Mobil", I want adjacent cell in column C to automatically generate "gas/fuel", cell in column B shows "grocery store" I want adjacent cell in column C to automatically generate "food". Is this possible? 

1 Reply
Highlighted

@mdion1819 

I'd suggest to use PivotTable on imported from csv data.