Vlook table array

[shonu1320]

When writing a vlookup, can my table_array be from a completely different excel file? Like I am writing a vlookup in one file but my table is in another excel file.
I wrote the following vlookup. It worked in the same file as EAU where Data is one of the tab but when I wrote the same formula in a different file and for my table array, I open another file called EAU in tab called data and copied the same array..my cell now shows this whole formula instead of the value of this formula.
What am I doing wrong? Please advice!

=if(iserror(if(isblank(A5),"",vlookup(A5,'[EAU.xlsx]Data'!B:C,2,0))),"NOT FOUND",IF(isblank(a5),"",vlookup(A5,'[EAU.xlsx]Data'!B:C,2,0)))

 

[Andrew Poulsom]

Make sure that the cell is formatted as other than Text before you enter the formula.

 

[shonu1320]

Silly me! It was the formatting. Thank you so much, you are the best