ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   vlookup displaying value of 0 (https://www.excelbanter.com/excel-worksheet-functions/189921-vlookup-displaying-value-0-a.html)

Hohner

vlookup displaying value of 0
 
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

vlookup displaying value of 0
 
For better answers, post your vlookup formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hohner" wrote in message
...
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:




Dave

vlookup displaying value of 0
 
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.


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com