v look up and rounding

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.
 
J

Jacob Skaria

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
 
H

hmz

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top