Hi,
I need to monitor a file out of the data obtained from another source.
The below works:
=IF(L4=VLOOKUP(L4,'CSVAssetRegister4_5_2017 3_50_06 PM.xlsx'!$N$2:$N$23084,1,FALSE),TRUE,FALSE)
But the below does not work & not giving correct result - content of N3 or "Not in SAR" even when it has to, instead it displays #N/A:
=If(AND(VLOOKUP(L3,'[CSVAssetRegister4_5_2017 3_50_06 PM.xlsx]CSVAssetRegister4_5_2017 3_50_0'!$N$2:$V$23084,1,FALSE)=L3,(VLOOKUP(N3,'[CSVAssetRegister4_5_2017 3_50_06 PM.xlsx]CSVAssetRegister4_5_2017 3_50_0'!$N$2:$V$23084,9,FALSE)=N3),N3,"Not in SAR")
Please suggest correction if any in the above formula.
Shreeniwas
Bookmarks