I am working on a workbook with two worksheets at present (One with cost prices and the second with formulas).
I am using vlookup from the second sheet to to find the part and price on sheet one (=VLOOKUP(G13,Sections,12) for example.
This works fine for all information entered before i created the Table Array 'Sections'. Now i am adding more parts but for some reason the formula cannot see the new parts and prices entered and is just leaving me with an empty cell instead of the amount it is suppose to show. I have tried refreshing the worksheet and still nothing.