I have an excel sheet named as “ITBricks”. In that I have 2 sheets named as “data” and “test”from the sheet “data” I want to read column G from the sheet “test” I want to read column “Expected” I want to compare both the columns and if both values are same I want to update in the sheet “data” column “H” as Pass or Fail.Please help me to do this

Cadet | Tier 2

Solved

Excel Operations

I have an excel sheet named as “ITBricks”. In that I have 2 sheets named as “data” and “test”

from the sheet “data” I want to read column G
from the sheet “test” I want to read column “Expected”
I want to compare both the columns and if both values are same I want to update in the sheet “data” column “H” as Pass or Fail.

Please help me to do this

This topic has been closed for replies.

Best answer by Shreya.Kumar

here’s a flow you can start off with!

here’s a flow you can start off with!