=IF($G6="","",IFERROR(VLOOKUP($G6, EquipmentData!$B$3:$C$95876, 2, FALSE),"Barcode Only Mode"))
Currently this formula displays 'Barcode Only Mode' when no match is found with the VLOOKUP. How can I modify so when no match is found, to only display 'Barcode Only Mode' IF Users!$M$1 = ON, otherwise it remains blank.
Bookmarks