I have a source sheet with 3 columns and 28 rows

Column 1 contains numbers (formated as text (i.e. '1400)
Columns 2 Long Description (Toronto)
Column 3 Short Description (TOR)

In another sheet I have a cell which lists the name of the tab formula

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If the tab is named 1400 my vlookup works, if it is named TOR it does not. I
have formated the vlookup table in text but I can still not get this to work..

I have to beleive it is a formatting issues but since I have formated
everything in text.....

What am I doing wrong

My vlookup formula is =VLOOKUP($A$4,'Dept List'!$A$2:$C$28,2,0)


thanks