SOLVED

IF Formula with multiple criteria with

%3CLINGO-SUB%20id%3D%22lingo-sub-1472972%22%20slang%3D%22en-US%22%3EIF%20Formula%20with%20multiple%20criteria%20with%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472972%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20was%20trying%20to%20if%20function%20for%20finding%20the%20same%20criteria%20in%20the%20above%20rows%20with%20multiple%20criteria%20based%20with%20if%20condition%20it's%20possible%20please%20help%20us.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%221000%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EA%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3EB%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EC%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3ED%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3E%3CSTRONG%3EIRN%20Number%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E%3CSTRONG%3EIRN%20Date%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3E%3CSTRONG%3EVendor%20Code%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3E%3CSTRONG%3EVendor%20Name%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3E%3CSTRONG%3EInvoice%20No%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105028%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0240%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20SRI%20KARTIKEYA%20POLYMERS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3E49%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E4%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E5%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E6%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E7%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E8%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E9%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E10%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E11%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E12%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2295px%22%20height%3D%2230px%22%3E13%3C%2FTD%3E%3CTD%20width%3D%22199px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%22131px%22%20height%3D%2230px%22%3E30-May-2020%3C%2FTD%3E%3CTD%20width%3D%22138px%22%20height%3D%2230px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22328px%22%20height%3D%2230px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%22108px%22%20height%3D%2230px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20was%20trying%20formula%20in%20A14%20trying%20with%20if%20formula%2C%20actually%20i%20want%20the%20IRN%20Number%20%22IRN%2F202105030%20if%20C14%20%3D%20V0369%20%26amp%3B%20E14%3D%20ME%2F2%2C%20if%20nothing%20in%20C14%20and%20E14%2C%20it%20will%20come%200%2C%20but%20i%20dont%20get%20the%20formula%20please%20help%20us%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1472972%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1473109%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Formula%20with%20multiple%20criteria%20with%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1473109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702076%22%20target%3D%22_blank%22%3E%40sreekittu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20a%20formula%20in%20A14%20which%20populates%20A14%20with%20matching%20IRN%20Number%20for%20the%20Vendor%20Code%20entered%20in%20C14%20and%20Invoice%20No%20entered%20in%20E14%2C%20please%20try%20something%20like%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(OR(C14%3D%22%22%2CE14%3D%22%22)%2C0%2CIFERROR(INDEX(%24A%242%3A%24A%2413%2CMATCH(C14%26amp%3BE14%2CINDEX(%24C%242%3A%24C%2413%26amp%3B%24E%242%3A%24E%2413%2C)%2C0))%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20per%20the%20above%20formula%20if%20you%20enter%20V0369%20in%20C14%20ad%20ME%2F2%20in%20E14%2C%20the%20formula%20would%20return%20IRN%2F202105030%20in%20A14.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1473124%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Formula%20with%20multiple%20criteria%20with%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1473124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702076%22%20target%3D%22_blank%22%3E%40sreekittu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22804%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%20Number%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3EIRN%20Date%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EVendor%20Code%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EVendor%20Name%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EInvoice%20No%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105028%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0240%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20SRI%20KARTIKEYA%20POLYMERS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3E49%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F3%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F3%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F3%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105029%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F3%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2257px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2257px%22%3E30-May-20%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2257px%22%3EV0369%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2257px%22%3EM%2Fs%20MARUTI%20ELECTRICALS%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2257px%22%3EME%2F2%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%3CSTRONG%3ERESULTS%20BELOW%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3CSTRONG%3EFORMULA%20USED%20ON%20EACH%20ROW%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2288px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2288px%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2288%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2288px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2288px%22%3E%3DIF(AND(C2%3D%24F%241%2CE2%3D%24G%241)%2CA2%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2288px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2288px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2288px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C3%3D%24F%241%2CE3%3D%24G%241)%2CA3%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C4%3D%24F%241%2CE4%3D%24G%241)%2CA4%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C5%3D%24F%241%2CE5%3D%24G%241)%2CA5%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C6%3D%24F%241%2CE6%3D%24G%241)%2CA6%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C7%3D%24F%241%2CE7%3D%24G%241)%2CA7%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C8%3D%24F%241%2CE8%3D%24G%241)%2CA8%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C9%3D%24F%241%2CE9%3D%24G%241)%2CA9%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C10%3D%24F%241%2CE10%3D%24G%241)%2CA10%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C11%3D%24F%241%2CE11%3D%24G%241)%2CA11%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C12%3D%24F%241%2CE12%3D%24G%241)%2CA12%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3EIRN%2F202105030%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C13%3D%24F%241%2CE13%3D%24G%241)%2CA13%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C14%3D%24F%241%2CE14%3D%24G%241)%2CA14%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C15%3D%24F%241%2CE15%3D%24G%241)%2CA15%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%20height%3D%2230px%22%3E%3DIF(AND(C16%3D%24F%241%2CE16%3D%24G%241)%2CA16%2C%22%22)%3C%2FTD%3E%3CTD%20width%3D%2280px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2279px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1473875%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Formula%20with%20multiple%20criteria%20with%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1473875%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20working%20but%20i%20need%20one%20more%20formula%20add%20with%20existing%20your%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20return%20same%20IRN%20number%20will%20come%20no%20Problem%2C%20but%20if%20answer%20is%20%220%22%20means%20i%20need%20next%20IRN%20number%20in%20the%20last%20IRN%20number%20(exmple%20IRN%2F202105030%20is%20Last%20IRN%20number%2C%20but%20i%20need%20IRN%2F202105031%20in%20next%20%220%22%20Place%2C%20please%20help%20me%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1474657%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Formula%20with%20multiple%20criteria%20with%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1474657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702076%22%20target%3D%22_blank%22%3E%40sreekittu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOkay%2C%20give%20this%20a%20try%20and%20see%20if%20this%20is%20what%20you%20are%20trying%20to%20achieve.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(OR(C14%3D%22%22%2CE14%3D%22%22)%2C0%2CIFERROR(INDEX(A%242%3AA13%2CMATCH(C14%26amp%3BE14%2CINDEX(C%242%3AC13%26amp%3BE%242%3AE13%2C)%2C0))%2C%22IRN%2F%22%26amp%3BMAX(INDEX(SUBSTITUTE(A%242%3AA13%2C%22IRN%2F%22%2C%22%22)*1%2C))%2B1))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480481%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Formula%20with%20multiple%20criteria%20with%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480481%22%20slang%3D%22en-US%22%3E%3CP%3EHI%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EActually%20its%20working%2C%20but%20IRN%2F202105002%20meaning%20is%20%22Item%20Receipt%20Note%22%20(IRN)%2F%202021%20means%20Fy%20Year%20is%202021%2C%2005%20Means%20Month%20of%20IRN%2C%20002%20means%20Serial%20Number%20in%20the%20IRN%20month%2C%20so%20i%20need%20if%20IRN%2F20210503%20will%20come%20the%20answer%20it%20will%20show%20the%20IRN%2F202105004%2C%20if%20IRN%20revived%20in%201st%20Date%20in%20June%20answer%20will%20come%20IRN%2F202106001%2C%20so%20please%20try%20the%20formula%20like%20this......%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, i was trying to if function for finding the same criteria in the above rows with multiple criteria based with if condition it's possible please help us.

 

 

 ABCDE
1IRN NumberIRN DateVendor CodeVendor NameInvoice No
2IRN/20210502830-May-2020V0240M/s SRI KARTIKEYA POLYMERS49
3IRN/20210502930-May-2020V0369M/s MARUTI ELECTRICALSME/3
4IRN/20210502930-May-2020V0369M/s MARUTI ELECTRICALSME/3
5IRN/20210502930-May-2020V0369M/s MARUTI ELECTRICALSME/3
6IRN/20210502930-May-2020V0369M/s MARUTI ELECTRICALSME/3
7IRN/20210503030-May-2020V0369M/s MARUTI ELECTRICALSME/2
8IRN/20210503030-May-2020V0369M/s MARUTI ELECTRICALSME/2
9IRN/20210503030-May-2020V0369M/s MARUTI ELECTRICALSME/2
10IRN/20210503030-May-2020V0369M/s MARUTI ELECTRICALSME/2
11IRN/20210503030-May-2020V0369M/s MARUTI ELECTRICALSME/2
12IRN/20210503030-May-2020V0369M/s MARUTI ELECTRICALSME/2
13IRN/20210503030-May-2020V0369M/s MARUTI ELECTRICALSME/2

 

i was trying formula in A14 trying with if formula, actually i want the IRN Number "IRN/202105030 if C14 = V0369 & E14= ME/2, if nothing in C14 and E14, it will come 0, but i dont get the formula please help us

5 Replies
Best Response confirmed by sreekittu (New Contributor)
Solution

@sreekittu 

 

If you want a formula in A14 which populates A14 with matching IRN Number for the Vendor Code entered in C14 and Invoice No entered in E14, please try something like this...

 

 

=IF(OR(C14="",E14=""),0,IFERROR(INDEX($A$2:$A$13,MATCH(C14&E14,INDEX($C$2:$C$13&$E$2:$E$13,),0)),0))

 

 

As per the above formula if you enter V0369 in C14 ad ME/2 in E14, the formula would return IRN/202105030 in A14.

 

@sreekittu 

IRN NumberIRN DateVendor CodeVendor NameInvoice NoV0369ME/2
IRN/20210502830-May-20V0240M/s SRI KARTIKEYA POLYMERS49  
IRN/20210502930-May-20V0369M/s MARUTI ELECTRICALSME/3  
IRN/20210502930-May-20V0369M/s MARUTI ELECTRICALSME/3  
IRN/20210502930-May-20V0369M/s MARUTI ELECTRICALSME/3  
IRN/20210502930-May-20V0369M/s MARUTI ELECTRICALSME/3  
IRN/20210503030-May-20V0369M/s MARUTI ELECTRICALSME/2  
IRN/20210503030-May-20V0369M/s MARUTI ELECTRICALSME/2  
IRN/20210503030-May-20V0369M/s MARUTI ELECTRICALSME/2  
IRN/20210503030-May-20V0369M/s MARUTI ELECTRICALSME/2  
IRN/20210503030-May-20V0369M/s MARUTI ELECTRICALSME/2  
IRN/20210503030-May-20V0369M/s MARUTI ELECTRICALSME/2  
IRN/20210503030-May-20V0369M/s MARUTI ELECTRICALSME/2  
RESULTS BELOW  FORMULA USED ON EACH ROW   
 
 

 

 
 =IF(AND(C2=$F$1,E2=$G$1),A2,"")   
   =IF(AND(C3=$F$1,E3=$G$1),A3,"")   
   =IF(AND(C4=$F$1,E4=$G$1),A4,"")   
   =IF(AND(C5=$F$1,E5=$G$1),A5,"")   
   =IF(AND(C6=$F$1,E6=$G$1),A6,"")   
IRN/202105030  =IF(AND(C7=$F$1,E7=$G$1),A7,"")   
IRN/202105030  =IF(AND(C8=$F$1,E8=$G$1),A8,"")   
IRN/202105030  =IF(AND(C9=$F$1,E9=$G$1),A9,"")   
IRN/202105030  =IF(AND(C10=$F$1,E10=$G$1),A10,"")   
IRN/202105030  =IF(AND(C11=$F$1,E11=$G$1),A11,"")   
IRN/202105030  =IF(AND(C12=$F$1,E12=$G$1),A12,"")   
IRN/202105030  =IF(AND(C13=$F$1,E13=$G$1),A13,"")   
   =IF(AND(C14=$F$1,E14=$G$1),A14,"")   
   =IF(AND(C15=$F$1,E15=$G$1),A15,"")   
   =IF(AND(C16=$F$1,E16=$G$1),A16,"")   

Thank you@Subodh_Tiwari_sktneer 

 

It's working but i need one more formula add with existing your formula

 

if return same IRN number will come no Problem, but if answer is "0" means i need next IRN number in the last IRN number (exmple IRN/202105030 is Last IRN number, but i need IRN/202105031 in next "0" Place, please help me@Subodh_Tiwari_sktneer 

@sreekittu 

Okay, give this a try and see if this is what you are trying to achieve.

 

=IF(OR(C14="",E14=""),0,IFERROR(INDEX(A$2:A13,MATCH(C14&E14,INDEX(C$2:C13&E$2:E13,),0)),"IRN/"&MAX(INDEX(SUBSTITUTE(A$2:A13,"IRN/","")*1,))+1))

 

HI@Subodh_Tiwari_sktneer ,

 

Actually its working, but IRN/202105002 meaning is "Item Receipt Note" (IRN)/ 2021 means Fy Year is 2021, 05 Means Month of IRN, 002 means Serial Number in the IRN month, so i need if IRN/20210503 will come the answer it will show the IRN/202105004, if IRN revived in 1st Date in June answer will come IRN/202106001, so please try the formula like this......