I want to know if the currency conversion which is the latest topic in the academy which has been done through StudioX can be done through the normal UiPath studio? How to use VlookUp which fetch data from one sheet and paste in other sheet as well as write value for each row of some duplicate data. In my case for the first few number it matches but not for others. Please find the attached image file.
VLookup will usually give you the first occurance value even if it is duplicated for multiple times @Pranav_Kashyap
So, you can simply use VLookup formula here to get the values. And normally Vlookup can be used to get data from multiple sheets or excels.