v look up and rounding

  • Thread starter Thread starter hmz
  • Start date Start date
H

hmz

I have a simple question, hopefullly.

I am new to the vlook up. I did a simple table:

Reference celll: 10.06%

A B C D
10.000% 281.8 3754 2860
10.100% 284.6 37537 28600

my formula is this: ==(VLOOKUP(10.06%,A1:D2,4))

I want my answer to deliver the result "28600." However, the formula is
rounding the 10.06% down to 10% and delivering a result of "2860" In other
words, anything above 10% is the next row.

Can someone tell me how to fix this rounding problem?

Thanks so much in advance.
 
If the 1st column is having entries such as 10.0, 10.1, 10.2, 10.3 etc then try
In cell E1 10.06%

=VLOOKUP(ROUNDUP(E1,3),A1:D2,4,0)

If this post helps click Yes
 
Thank you for your quick response.

I did your formula, and it worked, but the funny thing is that it does not
work for other numbers. for example see below: there must be something
fundamental to the area it is capturing. I just can not figure it out.


7.00% 197 2628 2002
8.00% 225 3003 2288
9.00% 254 3378 2574
10.00% 281.8 3754 2860 7.06%
10.10% 284.6 37537 28600

My error message is "N/A"

Sorry to keep asking. thank you,
 
Back
Top