| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP - when source empty, get "0". Change to complete emtpy?
StargateFanNotAtHome wrote:
On Fri, 01 Aug 2008 20:32:12 -0400, smartin wrote: Do I get you correctly, your source data sometimes has zero and sometimes has "X"? No. The source data will either have an X or will be blank. It's the calculation on the vlookup that is on the other sheet that is creating the zero when the source field is empty. Sorry I wasn't clear. If so, this overloading of the value field is the root of your problem because VLOOKUP will return zero in either case. Yet, you seem to say the source values mean two different things. So, you would be better off differentiating the values in the source: if zero means one thing (no discount) and "X" means something else (not sure what it means), put them in different columns in the source. It might be possible to write formulas with exception controls but in the end it will likely be easier to separate the metrics up front. It's just Excel returning a zero to represent the blank in the resulting VLOOKUP calculation, I'm guessing (?). That is correct. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Empty a cell if the values equal to "IN" , "MC" or "PP" | Excel Programming | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| How to change Import Data source folder "permanently"? | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| VLOOKUP gives duplicate results for "empty" searches | Excel Worksheet Functions | |||
Threaded Mode
