I have a master sheet calloed Users and Their User Groups. Col A is their userid and Col B is their assigned User Group. Then there is a blank form with entried for access levels and rights.
My other sheets look just like the blank one but filled in. I want to be able to Type in the user group I want to see and have it populated with the corresponding values from the worksheet it matches. Any help would be greatly appreciated. I have been trying to use HLOOKUP but can only get one col populated