vlookup displaying value of 0

[Hohner]

I have used a vlookup to search a file and find a result and if I llok at the
formula it shows the value I expected, but displays The number 0 in the Cell.
How can I fix this:

 

[Max]

For better answers, post your vlookup formula

 

[Dave]

Hi,
Without seeing your formula, the only thing I can think of is that the cell
is formatted incorrectly.
Format the cell as general, or an appropriate format for the data type you
expect in the cell.
Regards - Dave.