Dear All,
I would like to know the formula to fit my requirements:
I have the excel file which contain the workstations software inventory list and software valid list. I add column for the software valid or invalid on the software inventory worksheet, but there are a lot of the software version which is valid software e.g. MS office 2012, MS office 2016. The valid software list contain MS office , I want to find the keyword with MS office then return the value valid in the software inventory worksheet. I find the if + isna +vlookup can get the result, but vlookup cannot find the keyword MS office to return valid software.
May I know the formula to fit my requirements ?
Thank,
Hong
Bookmarks