still #N/A formula doesn't work

[iujfalvi]

Hi,

I have tried the indicated formula to eliminate #N/A from my table
based on the provided solutions.

as below

=IF(ISNA(VLOOKUP(A4;'G:\[Export.xls]Expor
All_Rel'!$D:$J;7;FALSE),"",VLOOKUP(A4;'G:\[Export.xls]Expor
All_Rel'!$D:$J;7;FALSE))

However excel 2000 returns me an error indicating the part

,"",VLOOKUP

Thanks in advance for any idea


Steve
Hungary

(e-mail address removed)

 

[Markus L]

=IF(ISNA(VLOOKUP(A4;'G:\[Export.xls]Export

All_Rel'!$D:$J;7;FALSE),"",VLOOKUP(A4;'G:\[Export.xls]Export
All_Rel'!$D:$J;7;FALSE))
However excel 2000 returns me an error indicating the part
,"",VLOOKUP

Check your "List separator" in Control Panel >> Regional Options >> Numbers.
Either it's "," or ";". Your formula uses both of them.
Replace all "," in your formula by ";".

 

[DDM]

....and note, iujfalvi, that you need to close the parentheses for your ISNA
function: =IF(ISNA(VLOOKUP(A4;'G:\[Export.xls]Export
All_Rel'!$D:$J;7;FALSE)),"", ... That seems to be the error that Excel is
highlighting.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

=IF(ISNA(VLOOKUP(A4;'G:\[Export.xls]Export
All_Rel'!$D:$J;7;FALSE),"",VLOOKUP(A4;'G:\[Export.xls]Export
All_Rel'!$D:$J;7;FALSE))
However excel 2000 returns me an error indicating the part
,"",VLOOKUP

Check your "List separator" in Control Panel >> Regional Options >> Numbers.
Either it's "," or ";". Your formula uses both of them.
Replace all "," in your formula by ";".