Excel Vlookup

Help
21

@Manjuts90

Getting same error

please find below workflow and output excel file which is not opeing

vlookup---- (1).xaml (10.5 KB)

Output.xlsx (10.2 KB)

22

@SagarSB i have made couple changes in workflow. Your excel file may be corrupted, try with new output excel file.

vlookup---- (1).xaml (10.5 KB)

23

@Manjuts90
ok …i will let you know

24

@Manjuts90

Its not showing expected value in Bucket column

25

@SagarSB try the workflow which i have sent u now. i think ur still using old one.

26

@Manjuts90

I am running u r provided workflow…
at your end what is the output in bucket column??

27

@SagarSB i am getting correct output. output sheet is corrupted create new one

28

@Manjuts90

can you please share which value u r getting in Bucket column

29

@SagarSB check the output i got below

Create new output sheet and run once again. In read range activity u must give output workbook not lookup workbook.

Check the formula once. Give correct formula like below

“=VLOOKUP(A2,‘D:\Users\user\Downloads[lookup.xlsx]Sheet1’!$E$4:$F$10,2,TRUE)”

1 Like
30

@Manjuts90
I will check it tomorrow and let you know…
Thank you