Vlookup #N/A return value
 

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(H61,10,IF(H6<0.6,1,IF(H6=0,"",VLOOKUP(H6,$C$4 5:$D$445,2,FALSE))))
--
Thank you,
"Ladysearcher" looking for knowledge

Vlookup #N/A return value
 

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



--
Regards,

Peo Sjoblom



"Ladysearcher" wrote in message
...
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(H61,10,IF(H6<0.6,1,IF(H6=0,"",VLOOKUP(H6,$C$4 5:$D$445,2,FALSE))))
--
Thank you,
"Ladysearcher" looking for knowledge

Vlookup #N/A return value
 

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" wrote:

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



--
Regards,

Peo Sjoblom



"Ladysearcher" wrote in message
...
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(H61,10,IF(H6<0.6,1,IF(H6=0,"",VLOOKUP(H6,$C$4 5:$D$445,2,FALSE))))
--
Thank you,
"Ladysearcher" looking for knowledge