View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Vlookup return NA for numbers format as general

I have a big problem.

Each time I use Vlookup for search in numbers, and those or formated as
general the sytem returns NA, and just changing the format does not works, as
I need to chagne it and retype all! but my table has 20 thousands for each of
those 5 sheets.

So there are anyway to sort this problem?

--
Marcelo