Could someone help me please. I've created a search box for a price list, but some of the values come up with #REF. After many attempts I noticed that each of the formulas I created on the price list page came up with a different result for the values highlighted in each column. The formula is the same for each column, the column numbers being the only difference - for instance:
Column A = code - the formula is =OFFSET(Pricelist!$A$3,0,0,COUNTA(Pricelist!$A:$A)-1). In this column, if I go to Name Manager and select the formula and click in the first part of the formula, it selects all the entries in that column.
Column D = colour - the formula is the same, but reads $D$3 and $D:$D. When I go to Name Manager and check this formula, it only selects the first 105 entries in the column. There are about 380 entries and more may be added at various stages.
I have formulas for five other columns and they do exactly the same thing, but each column stops at a different entry.
I have never seen this before and I have no idea how to fix it.
I'm working in Excel 2007, but it's a 2003 document.
Thanks
Ria