Vlookup formula is not working as expected everytime

Help
, ,
1

Hi Team,

My vlookup formula works correctly sometimes and it will not work as expected rest times.

=IF(ISNA(VLOOKUP(AZ"+RowIndex.ToString+",[Input2.xlsx]Sheet2!A:E,3,)),VLOOKUP(BC"+RowIndex.ToString+",[Input2.xlsx]Sheet2!B:E,2,),VLOOKUP(AZ"+RowIndex.ToString+",[Input2.xlsx]Sheet2!A:E,3,))

now it is just copy and pasting the string value . MY question is when we write vlookup it should be '[input2,xlsx]Sheet2'! , but now it is just taking it as [Input2.xlsx]Sheet2!
Can anyone please help me .

Please find my workflow attached,

Regards,
PadminiMapping update.xaml (25.8 KB)

2

You are using vlookup for searching value in second file not in same?

3

Yes in second file

4

This is ryt reference for second file…
Have you try

=IF(ISNA(VLOOKUP(AZ"+RowIndex.ToString+",[Input2.xlsx]Sheet2!A:E,3,)),VLOOKUP(BC"+RowIndex.ToString+",[Input2.xlsx]Sheet2!B:E,2,),VLOOKUP(AZ"+RowIndex.ToString+",[Input2.xlsx]Sheet2!A:E,3,))

in excel manually

5

yes i tried it will prompt window to select file

6

will you share your project zip file or Your Files with dummy data

7

Give Full path of that file … try this first
'D:\UiPath\Output[Input.xlsx]Sheet1

1 Like
8

Yes i tried and it is running now :slight_smile: , but instead of hard coding can we give the path as dynamic variable?

9

yes you can :blush:

10

Please correct me if i am wrong , so i need to use Assign property to the file name and use the variable in formula?

11

Yes right :+1:

1 Like
12

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