Excel help

[alphadrag]

Hello all, i have attached images at the bottom for easier understanding of my problem.

Under this image, for V7, i am trying to write a formula to get the value from the other workbook named "Inputs by AL" at L7. (see next image) The problem is that, i am unable to do so. Can anyone tell me if i am doing the formula wrongly or anything. Thank you

[#2 · Accepted solution]

@alphadrag 

The number format of V7 is set to Text. This causes the cell to display the formula.

Change the number format to General.

Then press F2 to edit the formula and press Enter without changing anything. The cell should then display the result

[#3]

Thank you. It worked