Seach element in Excel

Help Studio
, ,
1

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.

2

@Ping_Pong

For this you can use Lookup Datatable activity

Hope this will help you

Thanks

3

@Ping_Pong

Check below for your reference

image
image908×395 24.7 KB

image
image1004×448 25.2 KB

Hope this will help you

Thanks

4

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

1 Like
5

Hi @Ping_Pong

I have created a workflow based on your requirement

Refer to the xaml below!

Main.xaml (9.3 KB)

Regards