Range doesn't exist error even after using "A"+(Statement_dt.Rows.IndexOf(row)+2).ToString

Help
, ,
1

Hello,

I am trying to update a cell with Vlookup and Write cell in excel application scope it says range doesn’t exist.
Here i wanted to update the cells where the value is blank or #n/a using IF(ISNA) formula.
Please find my xaml attached and let me know what is wrong with the workflow.

Flowchart1.xaml (12.3 KB)

Thanks in Advance!

Regards,
Padmini

1 Like
2

Hello @chandrashekar_padmin

WHAT ERROR u r getting?
can you share your file?

3

Try this
"=IF(ISNA(VLOOKUP(BA"+RowIndex.ToString+",Sheet2!A:E,3,0)),VLOOKUP(BD"+RowIndex.ToString+",Sheet2!B:E,2,0),VLOOKUP(BA"+RowIndex.ToString+",Sheet2!A:E,3,0))"

2 Likes
4

Hello @ImPratham45,

Thanks much it has worked like a magic :slight_smile:

Regards,
Padmini

5

Your Most Welcome!!!

Happy Automation!

6

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