shlomi2020
New Member
- Joined
- Jan 17, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello,
I'm looking for a more effective way for the formula that i wrote :
=IF(B2= "","No Value",IF(ISNUMBER(SEARCH("*Simon Buskilla*",B2)),VLOOKUP("*Simon Buskilla*",$F$1:$G$4,2,0),IF(ISNUMBER(SEARCH("*Sapir Zur*",B2)),VLOOKUP("*Sapir Zur*",$F$1:$G$4,2,0),IF(ISNUMBER(SEARCH("*Shlomi Ohana*",B2)),VLOOKUP("*Shlomi Ohana*",$F$1:$G$4,2,0)))))
See the attached image.
Now I manually enter the names into the formula, I would like it to be automatic and I will only need to maintain the table = "worker name, Department".
I could only use a Vlookup but I used the formula because when appearing in the cell more than one name, Vlookup not working properly as in the "Business Names" column.
I would appreciate the help, Thanks.
I'm looking for a more effective way for the formula that i wrote :
=IF(B2= "","No Value",IF(ISNUMBER(SEARCH("*Simon Buskilla*",B2)),VLOOKUP("*Simon Buskilla*",$F$1:$G$4,2,0),IF(ISNUMBER(SEARCH("*Sapir Zur*",B2)),VLOOKUP("*Sapir Zur*",$F$1:$G$4,2,0),IF(ISNUMBER(SEARCH("*Shlomi Ohana*",B2)),VLOOKUP("*Shlomi Ohana*",$F$1:$G$4,2,0)))))
See the attached image.
Now I manually enter the names into the formula, I would like it to be automatic and I will only need to maintain the table = "worker name, Department".
I could only use a Vlookup but I used the formula because when appearing in the cell more than one name, Vlookup not working properly as in the "Business Names" column.
I would appreciate the help, Thanks.