I use Vlook up all the times , never have any problem, when I tried to use today to link 2 files to bring the cost, some how its not working

Vlook up formula is below .

is it this [@itemNumber] has anything to do with this ?

when I add the item number from my file , that's the way its picking it up, because this file was export from Blue star software ,

if that's what's causing the issue


=VLOOKUP([@ItemNumber],Sheet3!A2:F26349,6,false)

can any one help, I have tried every thing , I can think of,

I have used this function so many times , never have any issue

thanks in advance