Hi guys/girls,

I am new to this and am looking to see if anyone can solve my problem. I few tables worth of data in one sheet. I want to pull data to another sheet based on a given value/indicator. I have tried using Index & Match functions together but had some problems as the indicator comes up more than once in some tables. I want to consolidate data for each team separately in another sheet - for example, I want to show the projected stats for everyone on New Orleans (NO in column A). Can anyone help me with this?

Thanks a bunch!

-Joe


Fantasy Football 2013b.xlsx