VLOOKUP Function Query

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

can you upload the excel @Ishan_Shelke

Hi @Ishan_Shelke

You can try this

xaml for reference

StockNotAvailable.xaml (7.2 KB)

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

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

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

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