Vlookup #N/A return value

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

Guest

I am using VLookup and the value I am looking for in the look up table is a
calculated percentage. The field has been formated as a percentage to 1
position past the decimal. (i.e.: 99.9%) The table has approximately 400
sets of values in it. The look up column in the table is formated as
percentage to 1 position past the decimal, however these fields have been
manually entered. One of the values within the table is 99.9%; however the
result is #N/A. If I change the format of the calculated value to General,
it shows 0.998888889. Is this the reason the VLookup won't return the result
I am looking for? If so, what can I do to fix it.

My formula is:
=IF(H6>1,10,IF(H6<0.6,1,IF(H6=0,"",VLOOKUP(H6,$C$45:$D$445,2,FALSE))))
 
Formatting has nothing to do with it, copy both cells that you know/think
are a match somewhere else, if they are derived from formulas paste special
as values and then format as general and compare them. Formatting is just
the way something is displayed You might need to use the ROUND function to
get a match
 
Thank you so much. I knew it was probably an easy answer, I just couldn't
see it. Your help is much appreciated.
--
Thank you,
"Ladysearcher" looking for knowledge


Peo Sjoblom said:
Formatting has nothing to do with it, copy both cells that you know/think
are a match somewhere else, if they are derived from formulas paste special
as values and then format as general and compare them. Formatting is just
the way something is displayed You might need to use the ROUND function to
get a match
Click to expand...
 
Back
Top