Using and IF, Lookup and Find Formula

[ExcelN00b24]

I am attempting to write a formula to rate and Look up a few text strings. The largest strinng looks like this: Windows 7 // Windows 8 // Windows 10
but some of the text strings are a combination of all three IE. Windows 7 // Windows 8

I would like the formula to return three different values Windows7=2 Windows 8=4, and Windows 10 =8
If the string has all three then it should return the highest Value. Any suggestions for this?

[daffodil11]

=IF(FIND("Windows 10",A1),8,IF(FIND("Windows 8",A1),4,IF(FIND("Windows 7",A1),2,"")))

[ExcelN00b24]

Thank you for your help! This worked for only the ones that had all three Windows 7 // Windows 8 // Windows 10 but the ones like Windows XP // Windows 7 it returned # VALUE


any trouble shooting suggestions for this?

[daffodil11]

You only gave me three types in your original post. You'll need to include those in your list as well.

=IF(FIND("Windows 10",B11),8,
    IF(FIND("Windows 8",B11),4,
    IF(FIND("Windows 7",B11),2,
    IF(FIND("Windows XP",B11),1,""))))

[ExcelN00b24]

and what if some of the cells are Blanks?

[ExcelN00b24]

Also says I have entered too many arguments when I add XP

[Phuocam]

Try this ...

=LOOKUP(2,1/SEARCH({"*","XP","Windows 7","Windows 8","Windows 10"},A1&" "),{"","XP",2,4,8})

[ExcelN00b24]

AmAZING THANK YOU!!

[Phuocam]

You're welcome!