How to apply Vlookup in excel without using modern design?

[ozgecatak]

Hi everyone!

I have to use excel formula which is VlookUp in my process. But I should apply it without Uipath Modern Experience properties. I have 49660 invoice IDs. I should compare with other sheet’s Invoice ID. How can I do it?

Thanks a lot

[Sudharsan_Ka]

HI @ozgecatak

You can try with lookup datatable it will be working on datatable

How to Lookup Data Table in UiPath - Full tutorial

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Hi @ozgecatak

Do you have any specific reason to avoid VLOOKUP activity? You can try with that also

Check out this video and docs

VLOOKUP Tutorial for Excel - Everything You Need To Know

https://www.extendoffice.com/documents/excel/5053-excel-vlookup-copy-formatting.html

https://docs.uipath.com/activities/docs/v-lookup-x

Regards
Gokul

[balraj.krishnappa]

Hi,

First type in VLoookup formula in the first row of required column(Write Cell).

Next use “Select range”, select all 49660 rows of the required column.

After selecting send hotkey “Ctrl + Down”

Using this method you can do Vlookup without Modern Activities.

Thank you

[sandeep_sonu (sandeep B)]

HI @ozgecatak ,

With the help of read range ,write cell and autofill activities you can achieve the same

1. Use the read range activity to get the entire range of sheet
2. Use the Write cell activity to write the formula in the first cell of the column where you want to apply the formula
3. Use the Auto fill Range activity to apply the formula to the entire range.
   
   

Hope This helps !

[ozgecatak]

I use this method, it worked. Thank you !