How can we check value from one cell of excel sheet to each row of another excel sheet

how can we check date from one cell of excel sheet to each row of another excel sheet of column k and if date is match then copy value of same row of column “L”. Once it has been copied then write it in sheet1.

kindly help me to resolve this.

1 Like

Hi! Sachin

In you workflow you can add a Stream lookup step with the required condition to lookup column K and fetch a value from column L.

Please do share your workflow once it is complete.

1 Like