How to compare two columns B&C with columns F&G only values start with letter “V” and write in the remarks in column D & H
First condition: Compare values which start with letter V If material Column B Matching with material Column F but Qty Column C is Not Match with Qty column G then write in remarks column H “Qty Not available” Highlight in Yellow colour
Second Condition: Compare values which start with letter V If Material Column B and Qty Column C both are not matching with Material Column F and Qty Column G then write in remarks column D “Material and Qty Not available” and Highlight in RED colour
Third Condition: Compare values which start with letter V If Material Column F value and Qty Column G are only available in column F & G but not available in B& C then write in remarks column H “New” and Highlight in Green Colour
The solution can be tried using Vlookup formula in one cell and autofill range in all the other Cells.
But I’m not sure about the Filter of V starting letter , SO once the formula applied in all cells you can read the Value and Filter datatable.