Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a 1000 row 6 column table I look up based on row 1. I only have data
up to row 850. The remaining bad rows are for future items to be added. Unfortunately, when I try to fill in one of the blank rows with data, or if I try to change an existing line item to something else, my results from column 3 come back 20 rows off. Exactly 20 rows, therein I thought might be a hint? It doesn't always cause an error, but it does the majority of the time. Any advice GREATLY appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |