How Can make Vlookup between csv sheet and xls sheet

Learn Academy Feedback
, ,
1

Dear All how can make Vlookup between CSV sheet and xls sheet
i trid to do that with Vlookup activity but i don’t know how i can fill the input

and also how i can change any Value from NA to 0

Any help please

Screenshot987654

Screenshot1122334456
Screenshot11223344561900×947 45.9 KB

2

You can use the following formula. In case of NA, you can set it to 0.

image
image807×113 3.97 KB

Regards,
Karthik Byggari

3

Hi dear i don’t know how i can use Vlookup activity and make this condition
could you please Guid me please

=VLOOKUP(A:A,‘SC_Counter_Values_2019-02-05.csv’!$C:$D,2,0)

this is my Vlookup condition

4

Instead of vlookup,
You can use write cell activity to write the formula with a value -

“=IFERROR(VLOOKUP(A:A,‘SC_Counter_Values_2019-2-‘05.csv’’!$C:$D,2,0),0)”

In case of any error in the vlookup, the above formula writes 0 into that cell.

Regards,
Karthik Byggari

5

thanks dear for your support

please can you share with mw xaml i’m still idon’t understand how i can do
you mean i need first use
Excel Application Scope
Read Range
then
Excel Application Scope
Write Range
thnaks for your support as i’m still new in Uipath

6

Please let me know what you are trying to achieve. So I can share you the sample XAML.

Regards,
Karthik Byggari

7

Screen77665588
Screen776655881919×1041 121 KB

8

Vlookup xlsm sheet with CSV sheet and get the number from csv and paste in xlsm in column B

9

Ok. I will send you the XAML file by today.
If files are not confidential, please share the files to me.

10

hi @Mohamed_Abbas,
Refer this

Regards
Sanjay

11

LTE report - Copy.zip (472.4 KB)
SC_Counter_Values_2019-02-05.zip (628 Bytes)
@KarthikByggari

12

Please find the workflow.
TestProcess.zip (94.4 KB)

13

Hi Karthik,
I had 2 excel outputdata and Sample_2-new_invoices Apri. 14, 2017.
I had to validate output sheet data in Sample_2-new_invoices Apri. 14, 2017 using vlookup. Outputdata sheet has 3 column and i need to validate all 3 column in Sample_2-new_invoices Apri. 14, 2017. Please help me out. is it possible using vlookupoutputdata.xlsx (8.1 KB)
Sample_2-new_invoices Apri. 14, 2017.xlsx (19.5 KB)

14

This video may help: