Vlookup return NA for numbers format as general

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Since you didn't give an example of your VLOOKUP(), there are a couple
of possibilities:

1) Are you searching for text, e.g.,

=VLOOKUP(A:B,"1",2,FALSE)

?? If so, remove the quotes.

2) Are the numbers in your lookup range really numbers? Often values
pasted from web sites or other applications get pasted in as Text (try
=ISTEXT(A1) to see). If so, copy a blank cell, select your "numbers" and
choose Edit/Paste Special, selecting the Values and Add radio buttons.

If neither of these helps, post back with an example of both your
formula and the data set.
 
Back
Top