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!
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!