| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop #N/A until data in the reference cell
How can I keep cells blank (that have vlookup function in) until there is
data in the cell being referenced |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop #N/A until data in the reference cell
It depends exactly on how your formula works. The normal approach would
be: =IF(ISNA(your_formula),"",your_formula) But if the error is caused solely because of the reference cell being empty (assume this is A1), then you could also try: =IF(A1="","",your_formula) Hope this helps. Pete Colin wrote: How can I keep cells blank (that have vlookup function in) until there is data in the cell being referenced |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop #N/A until data in the reference cell
check the match function
=IF(ISNA(MATCH(arg1, arg2, arg3)), "", VLOOKUP(arg1, arg2, arg3, arg4)) "Colin" wrote: How can I keep cells blank (that have vlookup function in) until there is data in the cell being referenced |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop #N/A until data in the reference cell
Sorry, must be being a bit thick here. Tried that and cell stays blank all
the time. My formula is =vlookup(A1,Items,2) Items being the referecne chart on sheet 2, Any more on this thanks. "Pete_UK" wrote: It depends exactly on how your formula works. The normal approach would be: =IF(ISNA(your_formula),"",your_formula) But if the error is caused solely because of the reference cell being empty (assume this is A1), then you could also try: =IF(A1="","",your_formula) Hope this helps. Pete Colin wrote: How can I keep cells blank (that have vlookup function in) until there is data in the cell being referenced |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a cell reference bring the color of the data to the new sheet | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
Linear Mode
