| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
| When I open a Excel File it is corrupted and needs to be converte. | Excel Discussion (Misc queries) | |||
Threaded Mode
