Using Index/Match function

[KatrinaA]

I'm creating a Pipeline Spreadsheet with a Master list tab; Recently Opened tab, Under Construction tab, and Proposed tab. I need these three tabs to auto populate through a VLookup or Index/match function from master list. So for example any building with the Proposed Status on the Master will automatically be filled in with all the other information on the property(Name, City, State, etc) for the Proposed Tab. Can anybody help me with a formula for this? Any guidance is greatly appreciated!

[hoyasaxa215]

To automate this process you would need to use an array function. Here's an example where minimum mileage requirements are entered and a list of qualifying cars and models autopopulates. You could construct a file using an array that filters based on property type. Remember, arrays are entered by hitting ctrl+shift+enter. NOT JUST enter.

[KatrinaA]

I still cant get it to work. If I send you the document would you be able to see where I went wrong?

[KatrinaA]

I still cant get it to work. If I send you the document would you be able to see where I went wrong?

[hoyasaxa215]

Sure, just upload the file to this thread. If I can't figure it out, surely someone else will.

[KatrinaA]

Houston Pipeline 9.17.15.xlsx


Here is is
THanks

[hoyasaxa215]

Here's the file with the populated "Proposed" list. You can copy that sheet and change the status type to whatever other ones you'd like.

[Simon3]

Just curious, why not use pivot tables?