Hi All,
I've got a table with percentages running down the left side that I want to do a vlookup on. The percentages are in increments of 1, beginning at 4.1%. So I have 4.1, 5.1, 6.1 etc.
I'm using the round function to get integer results and then adding on the extra .1% to do the lookup. So my formula looks like VLOOKUP(ROUND(A1,2)+0.001,R1:T40,2,false) where A1 contains a random percentage value.
This works fine except for the value of 14.1%, which produces a N/A error on the vlookup function. I've tried re-entering 14.1% into the table. I've verified that my round function results in 14.1% by checking ROUND(A1,2)+0.001 = .141 and the result is true. The formula auditor shows nothing wrong until vlookup executes. I'm at a total loss, any help is appreciated! Thanks.
I've got a table with percentages running down the left side that I want to do a vlookup on. The percentages are in increments of 1, beginning at 4.1%. So I have 4.1, 5.1, 6.1 etc.
I'm using the round function to get integer results and then adding on the extra .1% to do the lookup. So my formula looks like VLOOKUP(ROUND(A1,2)+0.001,R1:T40,2,false) where A1 contains a random percentage value.
This works fine except for the value of 14.1%, which produces a N/A error on the vlookup function. I've tried re-entering 14.1% into the table. I've verified that my round function results in 14.1% by checking ROUND(A1,2)+0.001 = .141 and the result is true. The formula auditor shows nothing wrong until vlookup executes. I'm at a total loss, any help is appreciated! Thanks.