Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP for all rows
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP for all rows
ToolsOptionsEdit tab, check Extend data range formats and formulas
-- Kind regards, Niek Otten "DTTODGG" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP for all rows
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(A1<"",VLookup(A1,Data,2),"") and copy this down as far as is required. When data is entered in A, VLOOKUP will be invoked. Does this help? "DTTODGG" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP for all rows
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 "reinstate" the extend. I think it did work at one time, maybe the data entry person did something. I appreciate your help. "Niek Otten" wrote: ToolsOptionsEdit tab, check Extend data range formats and formulas -- Kind regards, Niek Otten "DTTODGG" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP for all rows
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 "DTTODGG" wrote in message ... 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 "reinstate" the extend. I think it did work at one time, maybe the data entry person did something. I appreciate your help. "Niek Otten" wrote: ToolsOptionsEdit tab, check Extend data range formats and formulas -- Kind regards, Niek Otten "DTTODGG" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
VLOOKUP to return multiple rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) |