Home

Apply formula to column depending on length of column being referenced

%3CLINGO-SUB%20id%3D%22lingo-sub-729175%22%20slang%3D%22en-US%22%3EApply%20formula%20to%20column%20depending%20on%20length%20of%20column%20being%20referenced%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729175%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3A%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20use%20a%20formula%20on%20a%20sheet%20(let's%20call%20it%20sheet%202)%20that%20references%20back%20to%20sheet%201%20columns.%20If%20there%20is%20a%20value%20in%20column%20A%20on%20sheet%201%2C%20the%20formula%20returns%20that%20value.%20If%20there%20is%20not%20a%20value%20in%20column%20A%20on%20sheet%201%2C%20the%20formula%20returns%20the%20value%20of%20column%20B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20way%20for%20the%20formula%20to%20automatically%20apply%20for%20the%20entire%20column%20A%20or%20B%20of%20sheet%201%2C%20even%20though%20the%20columns%20lengths%20will%20change.%20I%20am%20trying%20to%20make%20this%20a%20more%20automated%20process%2C%20so%20I%20want%20to%20avoid%20having%20to%20always%20drag%20down%20the%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditionally%2C%20I%20don't%20want%20to%20apply%20the%20formula%20to%20the%20entire%20column%2C%20as%20the%20resulting%200%20values%20will%20cause%20problems%20for%20other%20reasons.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%3A%3C%2FP%3E%3CPRE%3E%3DIF(PM_Columns!A2%3D%22%22%2CPM_Columns!B2%2CPM_Columns!A2)%3C%2FPRE%3E%3CP%3EThanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-729175%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
CESBoston
Occasional Visitor

Hi All: 

I'm trying to use a formula on a sheet (let's call it sheet 2) that references back to sheet 1 columns. If there is a value in column A on sheet 1, the formula returns that value. If there is not a value in column A on sheet 1, the formula returns the value of column B. 

 

I am looking for a way for the formula to automatically apply for the entire column A or B of sheet 1, even though the columns lengths will change. I am trying to make this a more automated process, so I want to avoid having to always drag down the formula. 

 

Additionally, I don't want to apply the formula to the entire column, as the resulting 0 values will cause problems for other reasons. 

 

I currently have:

=IF(PM_Columns!A2="",PM_Columns!B2,PM_Columns!A2)

Thanks! 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies