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))))
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))))