Hi,
I hope somebody can help me. I have a master table with all my data and I am trying to pull data from the mater table into another sheet. I do not want to pull all the columns from the master table, but just a couple and the data should be pulled based on a filter on one of the columns. Is this possible? I have tried to google and I suspect that I need to use index match formula but still struggling. Please help, it is fairly urgent.
I hope somebody can help me. I have a master table with all my data and I am trying to pull data from the mater table into another sheet. I do not want to pull all the columns from the master table, but just a couple and the data should be pulled based on a filter on one of the columns. Is this possible? I have tried to google and I suspect that I need to use index match formula but still struggling. Please help, it is fairly urgent.