vlookup is reporting 0 when I want it to show a blank cell

D

Dwade01

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi,

My vlookup formula is giving 0s when it encounters cells I've left blank my table. I'd like to know how I can get it to provide blank cells when it encounters blank cells.

Here's my formula string:

=VLOOKUP($C506,'Threats & Conservation Actions'!$B$3:$N$42,6,0)

Thanks!
 
J

John McGhie

The simple way might be to set the Sheet not to show 0 values. See the
Excel help topic "Control how zero values are displayed".

Otherwise, you will need an IF statement:

=IF(VLOOKUP($C506,'Threats & Conservation
Actions'!$B$3:$N$42,6,0)=0,"",VLOOKUP($C506,'Threats & Conservation
Actions'!$B$3:$N$42,6,0))

Hope this helps

=VLOOKUP($C506,'Threats & Conservation Actions'!$B$3:$N$42,6,0)

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top