| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF/ISBLANK formula
When using this formula =IF(ISBLANK(B2,"",VLOOKUP(B2,D2:E20,2,1)) I am
getting the #N/A error or incorrect data if the value in cell B2 starts with a 0 eg 07934. Any suggestions as to fix this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple cells with isblank formula | Excel Discussion (Misc queries) | |||
| IF AND ISTEXT ISBLANK formula | Excel Worksheet Functions | |||
| if(and(isblank( formula help | Excel Worksheet Functions | |||
| ISBLANK Formula Help | Excel Discussion (Misc queries) | |||
| ISBLANK Formula Help Request | Excel Worksheet Functions | |||
Threaded Mode
