Compare two columns data with other two columns data in same Excel

Help Studio
, ,
1

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

image
image893×320 15.7 KB

2

Hi @tkiran,

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.

3

Hi Priyanka Ramesh,
Thank you for your reply I will try to execute the same

1 Like
4

Hi Priyanka,

I could manage to write the not matching values output in column Q in the same excel, But now how to highlight the not matching values in column J. I have done the workflow …and I have attached it.

can u pls help me how to highlight in green color column J the values available which is column R ,

image
image1155×491 40 KB

BOM_Main.xaml (14.4 KB)

5

The Value similarities can again be Checked using Vlookup and Set the color in the Cell using the following .

Since the values might be in different cells and not continuous , each cell can be set color seperately.