I have two tables:
- The first table lists Items and the values that are acceptable for the "UOM" (Unit of Measure)
- The second table lists Items and has associated quantities with their UOM
I want a formula to verify that the UOM used in the second table is one that is listed in the first table and returns "UOM Correct" if it is or "UOM Incorrect" if it is not
In this example the second table Item 1 is incorrect because "EA" is not one of the values for Item 1 from the fist table. Item 2 is correct because "BUND" is one of the values from the first table.
Thanks for your help
- The first table lists Items and the values that are acceptable for the "UOM" (Unit of Measure)
- The second table lists Items and has associated quantities with their UOM
I want a formula to verify that the UOM used in the second table is one that is listed in the first table and returns "UOM Correct" if it is or "UOM Incorrect" if it is not
In this example the second table Item 1 is incorrect because "EA" is not one of the values for Item 1 from the fist table. Item 2 is correct because "BUND" is one of the values from the first table.
Item | UOM 1 | UOM 2 | UOM 3 |
Item 1 | SH | SF | BUND |
Item 2 | EA | LF | BUND |
ITEM | QTY | QTY UOM | QTY UOM ERROR |
Item 1 | 100 | EA | UOM Incorrect |
Item 2 | 100 | BUND | UOM Correct |
Thanks for your help