Hi, I'm new here but I have been wracking my brain trying to get this spreadsheet to work how I want it.
In column A of one worksheet I have a list of names ranging from Cell A1 to A155. On that same worksheet in Column M I will have a few different associated statuses that will change frequently. I want to make it so on another worksheet I can have a particular status being listed and whomever has it at that time from the name list can be referenced.
Not sure if I am explaining it right.
I tried doing LOOKUP but it would always pick the last person who had anything at all in the status column instead of who had the proper word, (ie Active,Inactive)
Any help would be greatly appreciated.
Bookmarks