Use vlookup formula in uipath

Hi Team,

For vlookup I dont want to make use of lookup datatable because there are many rows and for each is used

any other way to use vlookup
I have vlookup lookup formula with me
how to make use of write cell for this

Thanks and Regards,
Supriya

Hi,

I have vlookup lookup formula with me
how to make use of write cell for this

How about as the following?

img20211111-c

Regards,

Hi @Yoichi

will this work for 2 workbooks

Regards,
Supriya

Hi,

You already have formula, do you? Do you mean like the following?

img20211111-d

Regards,

Hi

by the above formula I m getting the values in R column
How to do this in uipath

Regards,
Supriya

There are around 6000 rows in this file

Hi,

In this case, we can use the following formula in any row.

=VLOOKUP(INDIRECT(ADDRESS(ROW(),8)),'D:\CRV\[ICICIPRU_LTST Rating - Copy.xlsx]Debt_Master'!$B$3:$M$958,12,FALSE)

So we can write it as the following if we know its range.

img20211111-e

Regards,

image
image

Hi,

first read your sheet to get count, the assign one variable for count,use write cell put vlookup formula and take auto fill range .

PFA screenshot.

Regards,

Hi

Getting the output as zero in all the rows

=VLOOKUP(INDIRECT(ADDRESS(ROW(),8)),‘D:\CRV[ICICIPRU_LTST Rating - Copy.xlsx]Debt_Master’!$B$3:$M$958,12,FALSE)

What is this 8 for in the above code

Regards,
Supriya

Hi,

This 8 means column H.
So INDIRECT(ADDRESS(ROW(),8)) returns cell value at Current Row and column H.
Is this same as your original formula?

Regards,

Thankyou for the help

One more query

After performing vlookup is there any way to store the column H and vlookup value in a different excel workbook

Thanks and Regards,
Supriya

Hi,

Can you try the following steps.

  1. Read table as datatable using ReadRange activity

  2. remove unnecessary column using FilterDataTable activity

  3. Write the datatable to workbook using WriteRange activitty

Regards,

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