VLOOKUP not 'showing' result

[Arman55]

imgur: the simple image sharer

Greetings everyone!
So I have been trying to explore this for far too long now, but now I gave up. I have this VLOOKUP formula which is supposed to take data from 'Table1' and show it to 'Table2', it shows the correct result on the function arguments window but in the column it shows #NA. Can anyone please help me with this?

 

[Andrew Poulsom]

Can you post some sample data and the formula you are using please?

 

[Andrew Poulsom]

Looking again, did you confirm the formula with Ctrl+Shift+Enter, not just Enter?

And welcome to MrExcel.

 

[mole999]

is it just some values that don't return, are they equal in format

 

[Arman55]

Hello, Thank you so much and really sorry for the late reply.

Here is the formula, All the columns and formats are correct.

"=VLOOKUP(Table2[[#This Row],[Item]]&"I"&Table2[[#This Row],[Date code]]&"I"&Table2[[#This Row],[Location]]&"I"&Table2[[#This Row],[Trailer]],CHOOSE({1,2},Table1[Item]&"I"&Table1[Date Code]&"I"&Table1[Location]&"I"&Table1[Trailer],Table1[Ndate]),2,0)"

The first thing is, I have two workbooks, one of them is correct (BackUp copy) and I am trying to copy paste the formula in the 2nd one because the formula was deleted from the 2nd one.
Two more things that I have discovered is, when I evaluate the formula, it gets the right values from Table2 but when on Table1, it shows #Value.
The other thing is, when I click the 'formulated' cell in the working workbook it appears in curly brackets, which does not appear when I copy it.
Hope I was able to explain myself.

 

[Arman55]

Hello, Thank you so much and really sorry for the late reply.

Here is the formula, All the columns and formats are correct.

"=VLOOKUP(Table2[[#This Row],[Item]]&"I"&Table2[[#This Row],[Date code]]&"I"&Table2[[#This Row],[Location]]&"I"&Table2[[#This Row],[Trailer]],CHOOSE({1,2},Table1[Item]&"I"&Table1[Date Code]&"I"&Table1[Location]&"I"&Table1[Trailer],Table1[Ndate]),2,0)"

The first thing is, I have two workbooks, one of them is correct (BackUp copy) and I am trying to copy paste the formula in the 2nd one because the formula was deleted from the 2nd one.
Two more things that I have discovered is, when I evaluate the formula, it gets the right values from Table2 but when on Table1, it shows #Value.
The other thing is, when I click the 'formulated' cell in the working workbook it appears in curly brackets, which does not appear when I copy it.
Hope I was able to explain myself.

 

[mole999]

the one tghat is missing the curly brackets, select your formula, then ctrl shift enter at the same time, the brackets should now appear, then drag the formula down as required

 

[Arman55]

Hey, thanks for the reply, I tried it but nothing changed.

 

[Arman55]

Sorry I wrote it too fast.... yes I tried it again in the formula bar and it worked this time. And its all set now... Thank you soo much and to everyone who replied above..