My Excel 97 was just upgraded to Excel 2000 - am now having problems with VLOOKUP. Always returns #NAME? Have created basic simple tables and tested and it still does not work. I went to Tools, Options, Calculations and made sure Accept Labels in Formulas is checked. What else can I be missing?
HookEm
HookEm