Dec 02 2020 10:49 AM
Hi experts!
Will try to explain as clearly as I can: I need to understand if an incorrect rate (>0%) was applied to orders based on specific material numbers (which should have a 0% rate).
I believe the logic should do the following:
If the material number in sheet 1 is present in sheet 2 (column 1) and the rate in sheet 1 for that row/order is > 0, the row in sheet 1 should return a value "incorrect rate" in column 47
I already formatted the sheets to allow number values to be recognised and to have the first columns match on both sheets as the initial column.
In case it is needed, I also applied the Name Manager to label certain columns:
Material_Order for sheet 1 material numbers in column 1
Material_Ref for sheet 2 material numbers in column 1
Order for sheet 1 in column 5
Rate for sheet 1 in column 21
Can anyone help me navigate the seas of formulas (IF, VLOOKUPS, AND, etc.) to get there as easily as possible?
Many thanks in advance!
Gratefully yours,
Rosalie
Dec 03 2020 06:00 AM
You've already identified some of the most likely functions to be used to resolve your situation.
Beyond that, I think the most helpful thing you can do to help us help you is post a copy of the actual spreadsheet, so long as no proprietary or confidential information is in it. If that's the case, post something that resembles it, but has nonsense names and labels.
Otherwise we're forced to try to re-create the layout from your verbal description, and that is far less productive than working with the actual layout.
Dec 03 2020 06:18 AM
Solution@RosalieH The attached example may help you find a solution to your question. If not, you can perhaps upload the file you are working on, after having removed any private and confidential information.
Dec 04 2020 07:00 AM
Dec 03 2020 06:18 AM
Solution@RosalieH The attached example may help you find a solution to your question. If not, you can perhaps upload the file you are working on, after having removed any private and confidential information.