Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-3118858%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3118858%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20percent%20of%20commission%20margin%20and%20need%20the%20formula%20to%20look%20up%20a%20value%20in%20a%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20H28%20%3D19.7%25%20so%20lookup%20on%20my%20chart%20that%2019.7%20%3D%203%25%20commission%20or%204%25%20or%20whatever%20it%20falls%20into.%3C%2FP%3E%3CP%3EI%20have%20a%20sample%20file%20I'm%20working%20on%20but%20do%20not%20see%20attachment%20key.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20a%20formula%20with%20Sheet2!A1%3AA5%20then%20you%20would%20enter%20B1%3Ab5%2C%20but%20no%20good.%26nbsp%3B%20Also%20tried%20a%20vlookup%20but%20just%20not%20getting%20it%20right.%26nbsp%3B%20Please%20let%20me%20know%20if%20you%20can%20assist.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3118858%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3119156%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3119156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1297546%22%20target%3D%22_blank%22%3E%40Donnalsh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20don't%20see%20an%20area%20below%20the%20box%20where%20you%20compose%20a%20post%20saying%20%22Drag%20and%20drop%20here%20or%20browse%20files%20to%20attach%22%2C%20you%20can%20upload%20a%20sample%20workbook%20to%20OneDrive%2C%20Google%20Drive%2C%20Dropbox%20or%20similar%2C%20obtain%20a%20link%20to%20the%20uploaded%20workbook%20and%20post%20the%20link%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a percent of commission margin and need the formula to look up a value in a chart.

 

Example: H28 =19.7% so lookup on my chart that 19.7 = 3% commission or 4% or whatever it falls into.

I have a sample file I'm working on but do not see attachment key.

 

I have tried a formula with Sheet2!A1:A5 then you would enter B1:b5, but no good.  Also tried a vlookup but just not getting it right.  Please let me know if you can assist.

1 Reply

@Donnalsh 

If you don't see an area below the box where you compose a post saying "Drag and drop here or browse files to attach", you can upload a sample workbook to OneDrive, Google Drive, Dropbox or similar, obtain a link to the uploaded workbook and post the link here.