vlookup and rounding - microsoft.public.excel.newusers

Message from discussion vlookup and rounding

teylyn

View profile

More options Nov 5 2009, 4:56 am

Newsgroups: microsoft.public.excel.newusers

From: teylyn <tey...@discussions.microsoft.com>

Date: Wed, 4 Nov 2009 12:56:01 -0800

Local: Thurs, Nov 5 2009 4:56 am

Subject: RE: vlookup and rounding

  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

Hi, you can try

=VLOOKUP(ROUNDUP(10.06%,1),A1:D2,4,FALSE)

This will round up the value to the nearest digit, so it is 10.1. Vlookup
then finds the exact match in your lookup table due to the FALSE operator.

does that help?

"hmz" wrote:
> 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.00%
> 10.10%

> 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.
> --
> hmz
> NY, NY

Forward