VLOOKUP Function Query

[Ishan_Shelke]

I have a Excel File Like This

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

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

Any Help is Appreciated

[jack.chan]

can you upload the excel @Ishan_Shelke

[kumar.varun2 (Varun Kumar)]

Hi @Ishan_Shelke

You can try this

xaml for reference

StockNotAvailable.xaml (7.2 KB)

[Ishan_Shelke]

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

[Ishan_Shelke]

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

[jack.chan]

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