Why Am I getting blank values on these cells? - Vlookup activity

Help Studio
, , ,
1

Hello, community. I’d like to know Why I’m getting blank values despite the target value row being the same as the other sheet value of the file. If this wasn’t working, it wouldn’t fill the first 2 cells.

image

The desired output is
image

This is the range of the sheet where It’s looking up for the value to match the cell value.

image

Please, any idea? Thanks a lot.

Here are the files:
1 - Copy.xlsx (16.7 KB)

Main.xaml (8.7 KB)

2

Hi @pprin001

Actually its strange i have even tried with excel formula it is throwing error but check into this workaround

1 - Copy.xlsx (16.7 KB)
Main.xaml (12.3 KB)

image
image682×900 36.1 KB

Hope this helps

Regards
Sudharsan

3

Hello, Thank you for your reply but I’m considering 1 row in the sheet “Hoja2” and this algorithm adds all the data table from testf4.

Any idea, how could I stop to copy all the datatable?

4

Hi @pprin001

I didn’t get you , can you elaborate ?

the workaround i send you is doing the same as your requirements

only difference you are using formula i am using the activity and finding the corresponding data with datatable

Regards
Sudharsan

5

Hi.

I have one row in “Hoja2” Sheet.
image

When I run the bot It adds all the datatable of the sheet"testf4".

image

The desired output should be

image

any idea, please?

1 - Copy.xlsx (16.7 KB)

6

HI @pprin001

Checkout this updated one
Main_Hoja.xaml (12.9 KB)
1 - Copy.xlsx (16.6 KB)

Regards
Sudharsan

7

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