Question about Computers & Internet
The problem doesn't say this explicitly, but it looks like you're using Excel. This answer depends on that assumption being correct.
Are you saying that some of your inputs are blank? And LOOKUP fails to map them to 0? Or are you saying that some of your values come back from LOOKUP as blanks? (They shouldn't; lookup should return either a value from the lookup table or an error.) Or is it the case that some input values get mapped to blank by your LOOKUP function?
Assuming that you're getting blanks back from LOOKUP where you wanted zeros -- for whatever reason -- here is something you can try.
It looks like the value you're looking up is in cell A3. Let's say your formula (the result of the LOOKUP) is in B3. In C3, you can put the formula =IF(ISBLANK(A3), 0, A3). This function tests if A3 is blank. If it is, it returns a 0. If it's not, you get A3 again. (But A3 has to really be blank -- spaces will count as non-blank.)
Then, you can copy data out of column C instead of column B, and it should have zeros in place of blanks.
Posted on Jan 06, 2008
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 01, 2016 | Microsoft Excel Computers & Internet
Sep 07, 2014 | Microsoft Excel for PC
Aug 12, 2017 | Microsoft Access 2002 for PC
Jun 27, 2011 | Computers & Internet
Oct 21, 2010 | Cameras
Jun 07, 2010 | Primavera SureTrak Project Manager 3.0 for...
Mar 24, 2009 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Computers & Internet
Apr 29, 2008 | Microsoft Excel for PC
Aug 20, 2007 | Microsoft Office Standard for PC
93 people viewed this question
Usually answered in minutes!