Adding Info to Second Column Based on the Previous

Help Robot
,
1

I have a Excel Sheet Like this :

image

What I want to Do is In the Stock Available Code Column Where Ever There is #N/A mentioned In the Remarks Column It should write as Stock Not Available

The Final Sheet Should Look like

image

Any Help is appreciated

The Sample Excel Sheet -
Book1.xlsx (9.0 KB)

2

Hey,
You can Use Read Range Activity Then
For Each row Activity
then in If condition you should mention

Current row(“Stock Available Code”).equals(“#N/A”)
then
write Cell
“Stock Note Available”
Else Condition
Continue Activity

Thanks

3

Hey

You can use this workflow
Main.xaml (8.5 KB)
Book1.xlsx (9.1 KB)

Thanks

4

This was not I was Looking For.

My Cell is not Empty It has a value #N/A

5

hey.
this is considering as empty cell
please keep the value in message box you will get understand
its not reading #N/A
Thanks

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.