How to use excel functions in uipath

[Palaniyappan (Forum Leader)]

@kumari_supriya

it is not showing the correct result,instead its showing #N/A
Is there any other way to do?

Fine that means your vlookup is correct but there is no value for the condition passed
Kindly check with the condition been applied and the output you want from

For this

@kumari_supriya

and once we do write cell for 1st cell how to do for whole column means drag.

Hope this could help you

How to stretch a formula

Hi, There are a couple ways to solve this, but this what I would do… First, you need to use the Select Range activity to select all cells where you want the formula. One way to find the last row you would need to probably use a Data Table from the sheet and use dt.Rows.Count to find the last row. Range would end up being something like this: “A2:C”+(dt.Rows.Count+1).ToString Then, you need to perform the Filldown key combination which is “Ctrl+d”. You can do this using TypeInto “[d(ctrl)]d[u(…

Kindly Try this and let know for any queries or clarification
Cheers @kumari_supriya