Use VLookup function

Hi,

I want to use Vlookup value to bring DivName column if the Cost Center is match
But it not working if i check Exact match box ,but when i unchecked it work but it bring wrong value

Please advise,


Hello @Mariam_Al_Ashwan ,

Please make sure that within the excel files, the data from the “Cost Center” column has the same format type (‘Number’ or "Text’).

Hope it helps!
Best regards,
Marius

Still not working

@Mariam_Al_Ashwan ,

The “Cost Center” column must be before your search columns.
Currently, within your excel files, the “Cost Center” column are on columns E, respectively I, while the “DivName” column are on B and E.

Please move “Cost Center” column at column A. In order for the VLOOKUP formula to work (no mater that it is excel, or UiPath), the search index column must be situated before the column you are searching for a result.

Hope it helps!
Best regards,
Marius

Hello @Mariam_Al_Ashwan

As per my understanding, you can read the excel and use the vlookup activity to search in the range instead of a loop.

Thanks

Thank you soo much it’s working now.i really appreciate your clear explanation

1 Like

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