Forum Discussion

PLG_Eng's avatar
PLG_Eng
Copper Contributor
Aug 04, 2020

Auto Result Population based on in Input in Another Cell

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)

 

 

 

excel
Formulas and Functions

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 04, 2020

    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.

    • PLG_Eng's avatar
      PLG_Eng
      Copper Contributor
      Aug 04, 2020

      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!