Vlook Up function not working Properly, donot know, need help

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

thanks for quick reply, its excel putting it there when I select the cell with vlook up value, and some of the item does have cost , where the data pulling it, when I enter this Vlook up formula
it stay as formula ,it does not convert it into formula, than I copy and paste into another sheet to test it if works it, it takes as formula it does not show now [@itemNumber] now show A3 but value does not show stiil

donot know why its doing it, ?

any advise will be helpful,

I am going frustrated

still not working

see attached the file, there are 2 tabs
Sheet 4 Column C has VLook up formula
to pulling the cost from sheet 5 column D

I think I have the correct formula, and some item does not have cost, but some do, vlook up at least pull the cost the item has cost

don't know why its not doing it

can you please help, that what's wrong with my formula

thanks again

Either you can try the formula mentioned above or you can convert the text into number in Sheet 5-Column A. By doing that, the formula which you had used, will get you result as you looking for.

Let me know if it works for you.

thanks Sixthsense

it worked great, I learn some thing new,

thank you very much

Adhawan06

how did you say I fix this arrow this also

use -before the column that will fix the arrow

its nice to know these tricks

thanks again