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

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)

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)

Hope this helps

Regards
Sudharsan

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?

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

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)

HI @pprin001

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

Regards
Sudharsan

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