Excel formula to Reference To different values in a table

I am currently working on a dynamic calculation of values based on what is typed into a cell on a different sheet inside of a work book. I have tried everything from different lookup functions to mat...