How to write formula in Excel Cell

Help Activities
, ,
1

Can someone help me to write the formula in cell ? Getting all 0.
“=IFERROR(VLOOKUP($C2,‘Sheet1’!$K:$K,3,FALSE),0)”

2

Hi,

For now, can you check formula in the cell if it’s same a what you expect.
It seems unnecessary to add escape character etc.

Regards,

3

@PALKUMARI_PATEL

As per explaination looks like your vlookup is failing for all…please try to manually input and check the value error

Cheers

4

Can you explain more what you are trying to say ?

5

Hi,

if you input the above formula manually, does it works? If it’s not same as what you expect, please review the formula itself. If it works, please check difference b/w manual input and UiPath input.

Regards,

1 Like
6

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