=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.
Hey Nitefox,
Perhaps
=IF($G6="","",IFERROR(VLOOKUP($G6, EquipmentData!$B$3:$C$95876, 2, FALSE),If(Users!$M$1="ON","Barcode Only Mode","")))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks