Hi everyone! I have attached a sample file for what I am trying to do...
I have a dropdown list which is populated from E2:E41. Cells F2:F41 correspond with the cells from E2:E41. When I choose from the dropdown list (cell A2) I want to output the corresponding F column cell in cell C2.
EX
In cell A2 I choose the value "Dropdown value 10" (cell E11). I want cell C2 to output "Output value 10" (cell F11).
It seems like there would be a simple if statement but I have not been able to figure it out. Please help! Thanks.
Bookmarks