I am trying to write a V-look up formula in one of the cell, and the formula is referencing to another sheet, but when I am using the “write cell” activity for the cell, it is not referencing to another sheet. By any chance any of you know the reason on how I can fix this issue ?
=IFERROR(VLOOKUP(F2&"*",'C:\Users\#Robotized Process Automation - Sources\IDOC Process Cleanup\Reference Sheets[Reference Sheet.xlsx]Solution Steps '!$B$2:$C$24,2,TRUE),“Submit a Helpdesk report for assistance”)
Even the manual vlookup with this formula will give the same output I guess…
There is error with this, are you trying to get the value of each row and make a VLookup?
Then there are two ways to do that
Easiest way :
Use F2 there and it will VLookup only for F2 row and then use auto fill range activity. The source range will be F2 and the destination will be the number of values you want to VLookup.
Declare a variable as count and increase the value everytime inside the loop and provide the range as “F” + count.tostring .
and the entire VLookup formula will be
“=IFERROR(VLOOKUP(F” + count.tostring “,'C:\Users#Robotized Process Automation - Sources\IDOC Process Cleanup\Reference Sheets[Reference Sheet.xlsx]Solution Steps '!$B$2:$C$24,2,TRUE),“Submit a Helpdesk report for assistance”)”
The formula works in excel, the * is to selected dynamic values from lookupsheet, I tried inserting the formula as a variable and that worked. Don’t know why it was not working when I was inserting values directly.