Forum Discussion
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)....
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.
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!
