LookupX cant find a value

I am using the activity LookupX to find a value in excel my activity looks like this
image
And I want to find the value 1 in the excel file


But it says this error when I execute the file
LookupX: The value 1 couldn’t be found in the range range 1-FACTURACIÓN!A:XFD. Check if the input range is valid as the formula works with either one column or one row selected.
The data is cleary in the excel and the range is correct idk what is wrong

@Juandix

May be the datatype of column is Number can you try with 1 without inverted comma around it

cheers

I still with tha same error
image

@Juandix

I see the range is given as A7:A38 is it in that range?

can you give only the sheet name to check

Excel.Sheet(“Sheetname”)

cheers

The error was the source of results, i remove it and it worked the problem is that when I want to print the result "That is the cell of the data that was found doesnt print anything

1 Like