View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
franciz franciz is offline
external usenet poster
 
Posts: 79
Default VLOOKUP #N/A Error

would you post your formula and elaborate more what you want to do.
if your formula is correct, using ISNA with the Vlookup formula
should solve your problem



"NM" wrote:

Hi,

I'm using a VLOOKUP formula and I'm getting a #N/A
error! The calculation steps show error at the 'lookup_value'.I've tried by
best but cannot work through it.Can you please let me know how to get rid of
this.

Thanks!