Vlookup error when exact match is represented

  • Thread starter Thread starter MikeG
  • Start date Start date
M

MikeG

I am having an issue where an exact match is available but
the lookup does not find it. Here is a sample of some
data:

Look this up From: To get:

3/6/2003 3/6/2003 180 0.032 0.032
3/17/2003 3/17/2003 180 0.034 0.034
3/24/2003 3/24/2003 180 0.0375 0.0375
4/1/2003 4/1/2003 180 0.0345 0.0345
4/8/2003 4/8/2003 180 0.0365 0.0345
4/22/2003 4/22/2003 180 0.035 #N/A
4/23/2003 4/23/2003 180 0.0355 #N/A
4/23/2003 4/23/2003 180 0.0355 #N/A
4/24/2003 4/24/2003 180 0.0355 #N/A
4/25/2003 4/25/2003 180 0.0345 #N/A


The formula references the value in column 1, compared to
column 2. Where a match is found, it returns the value in
column 4. All of the fields should have a match, but they
don't.

I can double click on the data in column b and the valus
is returned instead of the #N/A in column d.

This should not be. I am not changing the data in column
b, I just double clicked.

Thanks in advance for your help
Mike
 
Not as easy as it sounds. If one cell is formatted as text and the other as numeric, you cannot
simply change the format of the text cell to numeric using Format / Cells and have it work. You
need to coerce the textual data back to numeric. One way of doing this is to copy an empty cell,
select the data affected and do Edit / Paste Special / Add.
 
Back
Top