| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP function
When using the VLOOKUP function the search cell is blank, the destination
cell is getting a "0". Can this be changed so the destination cell will be blank also? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP function
Perhaps
=IF(C1="","",VLOOKUP(C1,A1:B100,2,FALSE)) Mike "zunw" wrote: When using the VLOOKUP function the search cell is blank, the destination cell is getting a "0". Can this be changed so the destination cell will be blank also? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP function
If your Vlookup range contains Blank then this could help =IF(VLOOKUP(D1,A1:B4,2,0)=0,"",VLOOKUP(D1,A1:B4,2, 0)) "Mike H" wrote: Perhaps =IF(C1="","",VLOOKUP(C1,A1:B100,2,FALSE)) Mike "zunw" wrote: When using the VLOOKUP function the search cell is blank, the destination cell is getting a "0". Can this be changed so the destination cell will be blank also? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP function
Mike,
Thx for your help. On an other place I found the answer: Tools/options/view/Zero values "Mike H" wrote: Perhaps =IF(C1="","",VLOOKUP(C1,A1:B100,2,FALSE)) Mike "zunw" wrote: When using the VLOOKUP function the search cell is blank, the destination cell is getting a "0". Can this be changed so the destination cell will be blank also? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP function
Which is not a good idea if there are cells which should show a zero.
Gord Dibben MS Excel MVP On Tue, 6 Nov 2007 01:20:00 -0800, zunw wrote: Mike, Thx for your help. On an other place I found the answer: Tools/options/view/Zero values "Mike H" wrote: Perhaps =IF(C1="","",VLOOKUP(C1,A1:B100,2,FALSE)) Mike "zunw" wrote: When using the VLOOKUP function the search cell is blank, the destination cell is getting a "0". Can this be changed so the destination cell will be blank also? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Linear Mode
