software

Hello-

I'm working on a spreadsheet where data is being manually entered everyday,
row-by-row. I have a VLOOKUP(A rownbr1, Data, 2) VLOOKUP(A rownbr2, Data, 2)
etc.

My question is: How can I have all rows as they are built, contain the
VLOOKUP command? Dynamically? Is this a syntax issue?

Thank you so much.

Toolsgt;Optionsgt;Edit tab, check Extend data range formats and formulas

--
Kind regards,

Niek Otten

quot;DTTODGGquot; gt; wrote in message ...
gt; Hello-
gt;
gt; I'm working on a spreadsheet where data is being manually entered everyday,
gt; row-by-row. I have a VLOOKUP(A rownbr1, Data, 2) VLOOKUP(A rownbr2, Data, 2)
gt; etc.
gt;
gt; My question is: How can I have all rows as they are built, contain the
gt; VLOOKUP command? Dynamically? Is this a syntax issue?
gt;
gt; Thank you so much.
You could put the VLOOKUP in an IF statement so the cell is blank if there no
data in cell A

for example ,

in cell B1=if(A1lt;gt;quot;quot;,VLookup(A1,Data,2),quot;quot;)

and copy this down as far as is required.

When data is entered in A, VLOOKUP will be invoked.

Does this help?

quot;DTTODGGquot; wrote:

gt; Hello-
gt;
gt; I'm working on a spreadsheet where data is being manually entered everyday,
gt; row-by-row. I have a VLOOKUP(A rownbr1, Data, 2) VLOOKUP(A rownbr2, Data, 2)
gt; etc.
gt;
gt; My question is: How can I have all rows as they are built, contain the
gt; VLOOKUP command? Dynamically? Is this a syntax issue?
gt;
gt; Thank you so much.

Thank you Niek - it's always something simple. But, I have that box checked
already? Could someone back space to make the formula not extend? Is there a
way to quot;reinstatequot; the extend. I think it did work at one time, maybe the
data entry person did something.
I appreciate your help.

quot;Niek Ottenquot; wrote:

gt; Toolsgt;Optionsgt;Edit tab, check Extend data range formats and formulas
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;DTTODGGquot; gt; wrote in message ...
gt; gt; Hello-
gt; gt;
gt; gt; I'm working on a spreadsheet where data is being manually entered everyday,
gt; gt; row-by-row. I have a VLOOKUP(A rownbr1, Data, 2) VLOOKUP(A rownbr2, Data, 2)
gt; gt; etc.
gt; gt;
gt; gt; My question is: How can I have all rows as they are built, contain the
gt; gt; VLOOKUP command? Dynamically? Is this a syntax issue?
gt; gt;
gt; gt; Thank you so much.
gt;
gt;
gt;

Maybe this from HELP:

To be extended, formats and formulas must appear in at least three of the five last rows preceding the new row.--
Kind regards,

Niek Otten

quot;DTTODGGquot; gt; wrote in message ...
gt; Thank you Niek - it's always something simple. But, I have that box checked
gt; already? Could someone back space to make the formula not extend? Is there a
gt; way to quot;reinstatequot; the extend. I think it did work at one time, maybe the
gt; data entry person did something.
gt; I appreciate your help.
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; Toolsgt;Optionsgt;Edit tab, check Extend data range formats and formulas
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;DTTODGGquot; gt; wrote in message ...
gt;gt; gt; Hello-
gt;gt; gt;
gt;gt; gt; I'm working on a spreadsheet where data is being manually entered everyday,
gt;gt; gt; row-by-row. I have a VLOOKUP(A rownbr1, Data, 2) VLOOKUP(A rownbr2, Data, 2)
gt;gt; gt; etc.
gt;gt; gt;
gt;gt; gt; My question is: How can I have all rows as they are built, contain the
gt;gt; gt; VLOOKUP command? Dynamically? Is this a syntax issue?
gt;gt; gt;
gt;gt; gt; Thank you so much.
gt;gt;
gt;gt;
gt;gt;