Cross sheet Formula to pull in column value
I have a Master Server Inventory sheet with columns such as Server Type, Server Name, Recovery Method, and several other columns with common data that has to be collected for all servers. I need to create a variety of separate sheets with detailed configuration data about each server. I want to reference and pull over the server names and server types into each detailed config sheet.
So I have a config sheet called Intel Network Interface Configuration Sheet. I need to populate this config sheet with all server names from the Master Inventory that have a Server Type = Intel in the master inventory.
What's the best formula to do this cross sheet formula? Index/Match? Could you provide an example.
The server name columns in the master inventory and config sheets will all share the same column name of "Server Name"
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!