Please assist me with Excel cell-related questions!

[22222222asas (그게 뭐라고)]

I’d like to input a value in cell B1 below the ‘part number’ cell. The ‘part number’ cell could either be B1 or C1. Please let me know how to do this. Thank you in advance.

[ushu (Usha kiranmai)]

Hi @22222222asas - Please check the below workflow

SampleWorkflow.zip (10.4 KB)

You can use Read Cell activity to read B1 and C1 cell. The output of the activity is the specific cell value. So, take if activity

If B1cellOutput.equals("PartNumber") 

Then >> Take **Write cell**  activity to write the value below B1 cell

else >> Take **Write cell**  activity to write the value below C1 cell

[22222222asas (그게 뭐라고)]

Thank you very much. However, the cell under the ‘part number’ could be random, ranging from B1 to H5. Could you please provide a method to achieve this? Thank you.

[ushu (Usha kiranmai)]

@22222222asas - Please check the attached workflow

SampleWorkflow.zip (10.9 KB)

Output

[22222222asas (그게 뭐라고)]

Thank you very much!
Have a nice day