Formula result not being displayed

[FLICK85]

Hello
I am hoping that this is very straightforward however has me stumped. I have a vlookup formula to return a result on a different sheet within the same workbook. Formula is:
=(VLOOKUP(A12,'Production Summary - DEC 19'!A:GG,172,FALSE))
The actual data should return 1000 but is actually returning 0. Before you say its because of the number stored as text or alike I have reviewed the reviewed the result in the function argument and it says the formula result is 1000. Why is it not displaying this?
Please help

 

[FLICK85]

I have attached a screenshot of the formula that is displaying 0

 

[Yongle]

Use this formula to determine which cell value is being returned and investigate

=ADDRESS(MATCH(A12,'Production Summary - DEC 19'!A:A,0),172,4)

 

[FLICK85]

Hello - thank you for responding
I have pasted this formula in and have attached the function arguments snip - not sure what this is showing me to be honest - are you able to help me a little more?

 

[Yongle]

Does formula in post#3 return the address of the cell you expect ?

if it does, what does this formula return ?
=INDEX('Production Summary - DEC 19'!FP:FP,MATCH(A12,'Production Summary - DEC 19'!A:A,0))

 

[FLICK85]

Hello - yes it is returning the cell number where the 1000 result is so looks good to me.

Ive pasted the index formula and that is coming up with 1000 in the function argument but what is actually visible is not 1000

 

[FormR]

Hi,

Do you have any custom formatting applied to the cell that contains the formula? Do you have any conditional formatting applied?

What does this formula return when placed in a spare cell?
='Production Summary - DEC 19'!FP11=1000

 

[FLICK85]

Hello

No conditional formatting - I have cleared it just to be 100% sure and no change to the original issue.

I have pasted this and it returns TRUE - is that what you would expect?

 

[FormR]

Hi, what about a custom number format? Try formatting the cell that contains the formula as general and see if that makes a difference.

 

[FLICK85]

Hello - I tried that earlier and it doesn't make any difference, as custom it displays "-" as general it displays 0. Very frustrating especially as the value is correct, I just cant see it.