cyclopz2004
New Member
- Joined
- May 12, 2011
- Messages
- 1
Ok so i am working on fish inventory and i have a list called "all" and i used an if statement and vlookup to import if the number of that type of fish i have is currently zero but its putting null for all of the ones that i do have more than zero of ex: IF(ALL!C3=0,VLOOKUP(ALL!C3,ALL!A3:ALL!H211,1,FALSE),"")
Ok 2nd thing is there any way for a formula to be written if i have a number the color red to use the vlookup formula?
Ok 2nd thing is there any way for a formula to be written if i have a number the color red to use the vlookup formula?