VLOOKUP Function Query

Help Robot
,
1

I have a Excel File Like This

image

In this My Stock Available Code Column is a Vlookup Function as you can see Below

image

Now When Information is not available in the Other Sheet, in this sheet the value is displayed as #N/A as you can see in the above Screenshots

What I want to do is Whereever #N/A values is seen in the Remarks Column I want to display value as stock not available like this

image

Any Help is Appreciated

2

can you upload the excel @Ishan_Shelke

3

Hi @Ishan_Shelke

You can try this

image
image549×530 12 KB

xaml for reference

StockNotAvailable.xaml (7.2 KB)

4

ATPDump.XLSX (54.5 KB)
CPC New Order Format (1).xlsx (13.8 KB)

5

I Tried Doing this. But the Assign Activity is doing Nothing in My Case

6

use this @Ishan_Shelke
Main (1).xaml (10.9 KB)