Formula to Pull Through Specific Data from one Table / Tab to another

**splottoman** · 12-11-2020, 02:48 AM

Hi,

I am working on a project and i need to give a breakdown of different statuses for properties i am surveying.

I am looking for a formula that will pull through to one tab properties that are only on hold and then on another tab properties that are out of scope.

I don't want all the data pulled across just certain relevant pieces.

I have hopefully attached a smaller version of what i am after.

Any help would be appreciated.

Many thanks

Steve

**bebo021999** · 12-11-2020, 02:56 AM

Out of scope, cell A2

=IFERROR(INDEX('Project Plan'!A:A,AGGREGATE(15,6,ROW(Table1[Survey Status])/(Table1[Survey Status]="Out of Scope"),ROW(1:1))),"")

Copy to next columns and change A:A to E:E
Copy column B to C and D

Similar to On Hold list

Formula to Pull Through Specific Data from one Table / Tab to another

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Formula to Pull Through Specific Data from one Table / Tab to another

Re: Formula to Pull Through Specific Data from one Table / Tab to another

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to pull through data by specific month

Formula to pull a specific field value from within a Pivot Table

[SOLVED] Should I use a formula or Macro to pull specific data from one tab to another

[SOLVED] Can't get IF,AND formula to pull specific data from another worksheet

[SOLVED] Need to pull Data out of Pivot Table into specific cells

[SOLVED] trying to get a formula that will pull data for a specific date.

Help searching through multiple tables to pull data into a specific table

Bookmarks

Bookmarks

Posting Permissions