Aug 04 2020 12:35 AM
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)
Aug 04 2020 12:57 AM
@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.
Aug 04 2020 01:39 AM
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!