Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2174815%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174815%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20containing%20multiple%20tabs.%20There%20is%20the%20main%20tab%2C%20Deliveries%2C%20and%20multiple%20other%20tabs%20that%20are%20labeled%20by%20a%20number.%20What%20I%20am%20trying%20to%20do%20is%20minimize%20the%20amount%20of%20copy%20%26amp%3B%20paste%20that%20I'm%20currently%20doing%2C%20and%20would%20like%20to%20use%20a%20formula%20that%20would%20pull%20over%20the%20data%20in%20columns%20A%20and%20G%20from%20the%20deliveries%20tab%2C%20and%20place%20them%20into%20columns%20A%20%26amp%3B%20B%20of%20the%20tab%206639808%2C%20if%20Column%20C%20on%20the%20delivery%20tab%20is%20the%20same%20as%20cell%20C%20on%20the%20tab%206639808.%20I've%20tried%20the%20IF%20and%20VLookup%2C%20but%20something%20does%20not%20seem%20to%20be%20working%20because%20I%20either%20get%20an%20error%2C%20or%20if%20a%20date%20pulls%20into%206639808%2C%20the%20dates%20do%20not%20match.%20I'm%20fairly%20certain%20this%20can%20be%20done%2C%20but%20even%20more%20certain%20that%20I'm%20going%20about%20it%20the%20wrong%20way.%20I%20have%20included%20a%20copy%20of%20my%20workbook%20below.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2174815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2174853%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F982288%22%20target%3D%22_blank%22%3E%40Enels2205%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20an%20example%20of%20how%20FILTER%20can%20work.%20It%20does%20require%20the%20most%20recent%20version%20of%20Excel%2C%20so%20if%20this%20doesn't%20function%20for%20you%2C%20let%20us%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DFILTER(Deliveries!%24A%242%3A%24A%24940%2CDeliveries!%24C%242%3A%24C%24940%3D'FHR%206639808'!D2%2C%22Not%20found%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2175224%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2175224%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20help!%20I%20think%20it%20will%20work%20for%20what%20I%20want%20to%20do.%20I%20am%20having%20an%20issue%20getting%20any%20results%20when%20I%20try%20the%20formula%20on%20my%20own.%20I%20copy%20and%20paste%20the%20formula%2C%20and%20I%20either%20get%20the%20actual%20formula%20without%20the%20start%20and%20end%20brackets%2C%20or%20when%20I%20add%20them%20in%2C%20all%20I%20get%20is%20%23NAME.%20I%20am%20in%20no%20way%20an%20excel%20wizard%2C%20but%20I%20do%20know%20and%20understand%20enough%20to%20know%20that%20it%20is%20a%20powerful%20tool%2C%20and%20I%20am%20either%20missing%20something%20or%20not%20doing%20something%20correctly.%20Maybe%20I've%20just%20spent%20too%20much%20time%20trying%20to%20figure%20this%20out%2C%20that%20I'm%20missing%20some%20simple%20step.%20I've%20included%20the%20workbook%20to%20show%20the%20issues%20when%20I%20try%20input%20this.%20They%20are%20in%20D4%20%26amp%3B%20D5%20on%20tab%206639808.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2175288%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2175288%22%20slang%3D%22en-US%22%3EI%20just%20realized%20that%20I'm%20using%20Excel%202013.%3C%2FLINGO-BODY%3E
New Contributor

I have a workbook containing multiple tabs. There is the main tab, Deliveries, and multiple other tabs that are labeled by a number. What I am trying to do is minimize the amount of copy & paste that I'm currently doing, and would like to use a formula that would pull over the data in columns A and G from the deliveries tab, and place them into columns A & B of the tab 6639808, if Column C on the delivery tab is the same as cell C on the tab 6639808. I've tried the IF and VLookup, but something does not seem to be working because I either get an error, or if a date pulls into 6639808, the dates do not match. I'm fairly certain this can be done, but even more certain that I'm going about it the wrong way. I have included a copy of my workbook below.

5 Replies

@Enels2205 

 

Here's an example of how FILTER can work. It does require the most recent version of Excel, so if this doesn't function for you, let us know.

 

=FILTER(Deliveries!$A$2:$A$940,Deliveries!$C$2:$C$940='FHR 6639808'!D2,"Not found")

@mathetes Thanks for the help! I think it will work for what I want to do. I am having an issue getting any results when I try the formula on my own. I copy and paste the formula, and I either get the actual formula without the start and end brackets, or when I add them in, all I get is #NAME. I am in no way an excel wizard, but I do know and understand enough to know that it is a powerful tool, and I am either missing something or not doing something correctly. Maybe I've just spent too much time trying to figure this out, that I'm missing some simple step. I've included the workbook to show the issues when I try input this. They are in D4 & D5 on tab 6639808. 

I just realized that I'm using Excel 2013.

@Enels2205 

 

If you can, upgrade to the newest version. FILTER and some of the other Dynamic Array functions are worth the effort.

 

Here's the video that introduced me to these. https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...
@mathetes Thanks for everything! I’m in the process of being upgraded as I type this!