Auto Result Population based on in Input in Another Cell

Copper 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!