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