Send cell through another workbook and return answer

or is this not possible using this layout?
do i need to approach it differently?

This is possibel the way you have it layed out. open both workbooks and write the formulas as you normally would.

Save

Not sure what you are looking for here.