how to find percentage value depends the data exist in another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2081313%22%20slang%3D%22en-US%22%3Ehow%20to%20find%20percentage%20value%20depends%20the%20data%20exist%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2081313%22%20slang%3D%22en-US%22%3E%3CP%3EI%26nbsp%3B%20am%20trying%20to%20find%20the%20percentage%20value%20of%20an%20item%20if%20it%20exist%20in%20another%20cell.%26nbsp%3B%20%26nbsp%3BThe%20rebate%20should%20be%20applied%20if%20it%20exist%20only%20in%20the%20cell%20A.%20Please%20help%20with%20the%20attached%20excel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2081313%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-2081413%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20find%20percentage%20value%20depends%20the%20data%20exist%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2081413%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F36830%22%20target%3D%22_blank%22%3E%40Polachan%20Paily%3C%2FA%3E%26nbsp%3BInserted%20two%20possible%20solutions%20in%20the%20attached%20file.%20One%20with%20VLOOKUP%20and%20one%20with%20XLOOKUP.%20See%20if%20the%20latter%20is%20supported%20by%20your%20Excel%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I  am trying to find the percentage value of an item if it exist in another cell.   The rebate should be applied if it exist only in the cell A. Please help with the attached excel

1 Reply

@Polachan Paily Inserted two possible solutions in the attached file. One with VLOOKUP and one with XLOOKUP. See if the latter is supported by your Excel version.