isladogs MVP / VIP Local time Today, 09:40 Joined Jan 14, 2017 Messages 19,111 Jul 19, 2020 #2 Use the Instr function to search for 'Battery' Condition:IIf(InStr([Material Details],,"Battery")>0,"Yes","")
Use the Instr function to search for 'Battery' Condition:IIf(InStr([Material Details],,"Battery")>0,"Yes","")
P premdasp premdasp Local time Today, 12:40 Joined Jul 7, 2008 Messages 5 Jul 19, 2020 #3 its now working Sir. Thanks...
isladogs MVP / VIP Local time Today, 09:40 Joined Jan 14, 2017 Messages 19,111 Jul 19, 2020 #4 You’re welcome