| 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? |
| 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 | |||
Threaded Mode
