Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Update
Excel 2007
=VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE) When using the above formula, if one of the cells in my table array is blank, I would like the resulting cell to remain blank - not show a 0 as it does now. Also, when I change a name in my table, it does not update in my drop down list? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Update
Hi,
Try this =IF(COUNTIF(Sheet3!$A$2:$A$47,C9)0,VLOOKUP(C9,She et3!$A$2:$F$47,2,FALSE),"") Mike "Canon" wrote: Excel 2007 =VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE) When using the above formula, if one of the cells in my table array is blank, I would like the resulting cell to remain blank - not show a 0 as it does now. Also, when I change a name in my table, it does not update in my drop down list? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Update
One way is to handle that blank using IF
=IF(VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE)="","",VL OOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "Canon" wrote: Excel 2007 =VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE) When using the above formula, if one of the cells in my table array is blank, I would like the resulting cell to remain blank - not show a 0 as it does now. Also, when I change a name in my table, it does not update in my drop down list? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Update
Thanks guys, that formula worked, but what about updating the table?
"Jacob Skaria" wrote: One way is to handle that blank using IF =IF(VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE)="","",VL OOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "Canon" wrote: Excel 2007 =VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE) When using the above formula, if one of the cells in my table array is blank, I would like the resulting cell to remain blank - not show a 0 as it does now. Also, when I change a name in my table, it does not update in my drop down list? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically update column index number in VLookup whe. | Excel Worksheet Functions | |||
trying to update a cell with new data based on vlookup functions | Excel Worksheet Functions | |||
vlookup doesn't update / recalculate | Excel Discussion (Misc queries) | |||
Automatic Function Result Update when using A VLOOKUP on another F | Links and Linking in Excel | |||
My first macro, uses Vlookup but doesnt update unless hit enter | Excel Worksheet Functions |