Compatibility issue with older versions of excel ( 97)

[Paul Naylor]

Hi All,

Need to convert newer version of excel to older version (97) . Run through the compatibility checker and for the following formula initially getting a #NAME? error , but then a False when changed to what I believe was the equivalent 97 command. Hoping someone can help?

Original Formula :

=IFERROR(VLOOKUP(G$3&G$2,'Raw Data'!$C:$FW,22,0),"N/A")

Revised formula ( compatible with excel 97):

=IF(ISERROR(VLOOKUP(G$3&G$2,'Raw Data'!$C:$FW,21,0)),"N/A")

 

[Eric W]

Try:

=IF(ISERROR(VLOOKUP(G$3&G$2,'Raw Data'!$C:$FW,21,0)),"N/A",VLOOKUP(G$3&G$2,'Raw Data'!$C:$FW,21,0))