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.
|