Seach element in Excel

Hi there,
I am new to uipath, I need a help with the
I have the “invoice” number as a string I want to search them on excel(1st coumn contains Invoice Number) and required company name (2nd Column) as output

Example
Invoice Company
123 TCS
346 Wipro
6578 Niclos

So If I have the invoice number as “6578”, I want output as “Niclos”

Please give any suggestions, thanks in advance.

@Ping_Pong

For this you can use Lookup Datatable activity

Hope this will help you

Thanks

@Ping_Pong

Check below for your reference

Hope this will help you

Thanks

Hey,
Firstly you need ‘read range’ Excel and store data into data table.
Next you can use activity ‘filter datatable’:
image
or you can use for each data row
and to get value from company column use CurrentRow(1).ToString
image

2 Likes

Hi @Ping_Pong

I have created a workflow based on your requirement

Refer to the xaml below!

Main.xaml (9.3 KB)

Regards