Vlookup fills in the Current Manager Name corresponding with the Current Manager. Now I am trying to get the file to fill in the Co-Manager column D. I want to do a vlookup using the store number in column A again, but need it to only return the name in Column B if the business title showing in column C contains Co-Manager?
A B C
Store# Current Manager Business Title
6005 Felisia Horton Store Manager
6056 Earlesha Mczeal Store Manager
6087 Diego Hernandez Store Manager (Nonexempt)
6090 Erica Martillo Store Manager
Bookmarks