Pulling data from a master table into another sheet

[Tatum2020]

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.

 

[Fluff]

As long as col F has store & col B is a different name from any others in that column, it should appear in the output.

 

[Tatum2020]

Hi, Column A has a different request number but the same requestor

Mastertable:

Summary Table: Request # 5 from Tom Jerry is not pulling in the summary table - only request # 5.

 

[Fluff]

That's because you asked for only one instance of each requestor.