| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double rows
I have copied a formula and it now takes up two rows as does the first one
the formula is=IF(G10="","",VLOOKUP(G10,I$1:J$67,2,0)) but can I make it so that the formula result is on one row only. -- Tim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Double rows
Check that the format of the cell with the formula in is not set to
wrap text, and adjust the width of the column to accommodate the length of the returned value. Hope this helps. Pete On Jul 25, 10:58 am, Tim wrote: I have copied a formula and it now takes up two rows as does the first one the formula is=IF(G10="","",VLOOKUP(G10,I$1:J$67,2,0)) but can I make it so that the formula result is on one row only. -- Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double lines | Excel Worksheet Functions | |||
| double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
| Double Criteria | Excel Worksheet Functions | |||
| Double IF - is this possible | Excel Worksheet Functions | |||
| Macro that double spaces rows for an entire worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
