still #N/A formula doesn't work

  • Thread starter Thread starter iujfalvi
  • Start date Start date
I

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)
 
=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
Click to expand...

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 ";".
 
....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


Markus L said:
=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
Click to expand...

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 ";".
Click to expand...
 
Back
Top