Formula that compiles a conclusive list of data from other tabs

**SAVAGE10489** · 10-12-2016, 12:06 PM

I am trying to create a Master Agreement List on the first tab of my document.**The 2nd tab is all the contracts my company owns.* The 3rd tab is all the leases my company owns.* I am trying to combine all the data*on the Contracts tab*and*all the data on the*Leases onto the same tab, the Master Agreement List, so the Master Agreement List*contains all of the info that are on the other tabs.* Can anyone tell me or know of a video that can teach me how to do this?*

So far I have tried: =IF(IF(ISBLANK(Contracts!A3)=TRUE,"",Contracts!A3)="","",IF(ISBLANK(Leases!A3)=TRUE,"",Leases!A3))
This is not working.* The output is only what data is in the lease tab...

Attached is a sample worksheet. The data is not fully compiled but there is sample data partially inserted.

Any thoughts?

-Savage

**Pete_UK** · 10-12-2016, 12:10 PM

You would probably need to use a formula with VLOOKUP or INDEX/MATCH functions in it, but it really depends how your data is laid out, and you have not really described that in your opening post.

It would help if you attached a sample Excel workbook, so we can see for ourselves how the data is arranged and what you want to do with it.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

**SAVAGE10489** · 10-12-2016, 12:49 PM

Thanks for your interest. I have added a sample worksheet as you suggested.

**JeteMc** · 10-13-2016, 09:39 PM

If I am correctly understanding the *and* then the master sheet would be populated by formulas similar to the following:

Formula:

Please Login or Register  to view this content.

Let me know if you have any questions.

Formula that compiles a conclusive list of data from other tabs

LinkBack

Thread Tools

Rate This Thread

Display

Formula that compiles a conclusive list of data from other tabs

Re: Formula that compiles a conclusive list of data from other tabs

Re: Formula that compiles a conclusive list of data from other tabs

Re: Formula that compiles a conclusive list of data from other tabs

Thread Information

Users Browsing this Thread

Similar Threads

Formula that looks up multiple tabs and returns a list

Creating TABS from a list and have these tabs have information populate automatically

[SOLVED] How do I set up a master sheet in a workbook that compiles data from the other sheets?

[SOLVED] Create list of tabs but do not include hidden tabs in the list

Create a master spreadsheet that automatically compiles and updates all data entered

[SOLVED] Indirect formula using Data Validation List of Worksheet Tabs

[SOLVED] How do I set up an Excel worksheet that compiles data from other .

Bookmarks

Bookmarks

Posting Permissions