I need help with the following task. I have an excel spreadsheet that consists of Room Status (consists only VAV and CAV). , Room Numbers (multiple rooms), Shop Name (multiple rooms) and Parent Loction (multiple rooms). My senario is when Room_No is picked, I want all fields (VAV_CAV,Shop_Name &Parent_Location ) related to that Room_No populated. A room is either CAV or VAV has a shop name and parent location.
Room Number (Room_No), Shop Name (Shop_Name) and Parent Loction (Parent_Location).