I have tried to update an excel workbook, the v lookup page. Unfortunately when I input the new details in the workbook it does not trigger the additions that I've made. Is there anyway I can edit the original table to accept changes.
Have changed the named range but still isn't doing what I want. For your information I didn't create this spreadsheet so I don't know if that would cause any problems and I've never created a spreadsheet with the look up function.