I created a prompt for site ID in a cell as follows: =UserResponse ("Query 1 with Service_DB" , "Enter Site ID"), which returns the site ID number. However, I would also like to display in multiple rows other data related to that site ID (eg. Site Name, Region, Mgr Name, Mgr ID) as my header. How should I do this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!