Upgraded to Excel XP, Excel 97 Vlookup's corrupted
We would like to upgrade to Excel 2002 or(XP) however we have a huge amount
of excel 97 files that are loaded with Vlookup formulas similar to
=VLOOKUP('F:\Prices-Dec 2004-Master Program\Master Pricing -
Pacesetter.xls'!Joist_Package_2,'F:\Prices-Dec 2004-Master Program\Master
Pricing - Pacesetter.xls'!Prices_To_Change,MATCH('F:\Prices-Dec 2004-Master
Program\Master Pricing - Pacesetter.xls'!Apaloosa_A_IX_Series,'F:\Prices-Dec
2004-Master Program\Master Pricing - Pacesetter.xls'!Model_List,0)+2,FALSE)
When we load on Excel 2002 all our Vlookup results have no answers (I can't
remember the exact symbol) so basically all our 100's of workbooks are
useless.
Our IT guys are stumped and tell me they can find no answer
Has any one had this happen? Help to find a cure would be fantastic. We
would love to upgrade.
Keith, having fun with my new hobby
|