Auto Result Population based on in Input in Another Cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1564526%22%20slang%3D%22en-US%22%3EAuto%20Result%20Population%20based%20on%20in%20Input%20in%20Another%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564526%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20%3CSTRONG%3ERespected%20Excel%20Community%3C%2FSTRONG%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20the%20below%20formula%20to%20return%20a%20value%20in%20Column%20B%20(%3CEM%3EBased%20on%20Input%20in%20Column%20A%2C%20the%20formula%20will%20lookup%20another%20table%20to%20return%20a%20match%20value%20in%20Column%20B%3C%2FEM%3E).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wondering%20how%20I%20can%20automate%20the%20execution%20of%20the%20formula%20(automatically%20return%20the%20desired%20match%20in%20Column%20B)%20once%20I%20input%20a%20value%20in%20Column%20A.%20Currently%2C%26nbsp%3B%20I%20input%20a%20new%20value%20in%20A%20(example%20in%20cell%20A3)%2C%20and%20then%2C%20I%20manually%20drag%20downward%20from%20cell%20B2%20to%20B3%20to%20return%20the%20desired%20value.%20I%20just%20would%20like%20to%20automate%20the%20returning%20of%20values%20in%20Column%20B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELOOKUP(2%2C1%2F(ISNUMBER(SEARCH(TRIM(%24D%244%3A%24D%24286)%2CA2)))%2C%24E%244%3A%24E%24286)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1564526%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%3CLINGO-SUB%20id%3D%22lingo-sub-1564582%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Result%20Population%20based%20on%20in%20Input%20in%20Another%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408917%22%20target%3D%22_blank%22%3E%40PLG_Eng%3C%2FA%3E%26nbsp%3BYou%20can%20achieve%20this%20by%20transforming%20your%20data%20in%20columns%20A%20and%20B%20into%20a%20structured%20table%20(Ctrl-T)%20%26nbsp%3BThe%20formula%20in%20column%20B%20will%20then%20automatically%20copy%20itself%20when%20you%20enter%20a%20new%20item%20at%20the%20bottom%20of%20the%20table%20in%20column%20A.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564652%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Result%20Population%20based%20on%20in%20Input%20in%20Another%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564652%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%20I%20did%20not%20think%20about%20this%20solution%20but%20it%20does%20accomplish%20what%20I%20want%20to%20do.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20again%2C%20thank%20you%20very%20much!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dear Respected Excel Community,

 

I am using the below formula to return a value in Column B (Based on Input in Column A, the formula will lookup another table to return a match value in Column B). 

 

I am wondering how I can automate the execution of the formula (automatically return the desired match in Column B) once I input a value in Column A. Currently,  I input a new value in A (example in cell A3), and then, I manually drag downward from cell B2 to B3 to return the desired value. I just would like to automate the returning of values in Column B. 

 

LOOKUP(2,1/(ISNUMBER(SEARCH(TRIM($D$4:$D$286),A2))),$E$4:$E$286)

 

 

 

2 Replies

@PLG_Eng You can achieve this by transforming your data in columns A and B into a structured table (Ctrl-T)  The formula in column B will then automatically copy itself when you enter a new item at the bottom of the table in column A.

Hi @Riny_van_Eekelen 

 

Thank you very much. I did not think about this solution but it does accomplish what I want to do. 

 

 

Once again, thank you very much!