现金流量表制作

318806..

请问各位大神  我这次excel操作现金流量表有这一个需求  我这边的现金流量都是按照银行流水明细做的  我这边根据=LOOKUP(,-FIND({"工资","奖金","劳务费","体检费","工伤","食堂费用","福利费","管理","水费","电费","货款","预付款","运费","物流费","投标保证金","标书费","固定资产","销差旅费","差旅费","公积金","社保","往来款","财务","企业","房产","土地","环保","印花","增值","城建","个税","下拨"},I3),{"职工现金","职工现金","职工现金","职工现金","职工现金","职工现金","职工现金","管理费用","管理费用","管理费用","货款","货款","销售费用","销售费用","销售费用","销售费用","固定资产","销售费用","职工现金","职工现金","职工现金","付分行款","财务费用","企业所得税","房产税","土地所得税","环保税","印花","增值税","城建税","个税","资金下拨","资金上收"})函数可以实现根据交易用途的关键字匹配得出大致用途分类  但是有些时候是需要先根据对方户名的关键字去先进行第一次的用途分类 再根据交易用途的关键字匹配出用途分类 但这一块的话就不知道如何制作公式了  就只能请教各位大神   谢谢~~

yfan17

但是有些时候是需要先根据对方户名的关键字去先进行第一次的用途分类
用途分类要求不明确，无法处理。

bs44bs

下载来看看

边缘码农

编制现金流量表，最好在现金和银行存款科目下挂现金流量辅助核算，编制凭证的时候指定现金流量项目，或者按照对方科目分类归集。

你的要求，按照我的理解，可以先建立一个户名分类对照表，然后用vlookup函数根据户名取分类。