Originally Posted by
Govind
Hi,
Build your table in the following way
Minimum value Percent
0 0%
500 2% and so on
Then use =VLOOKUP(A1,RANGE,2,TRUE)
where A1 is the cell where you have $700 and Range refers to the area
where you have your reference table.
Regards
Govind.
dark_snowboy wrote:
> I have a range of values below. How do i get the Percentage to show when
> i want to lookup a value of $700 from the table?
>
> A B
> Range Percent
> $0 - $499 0%
> $500 - $999 2%
> $1000 - $1499 5%
> $1500 - $1999 8%
> $2000 - $2499 10%
> $2500 - $2999 13%
> $3000 - $3499 15%
> $3500 - $3999 20%
> More than $4000 25%
>
> I know how to do the basic Vlookup for just a value, but im not sure
> how to do so for a range of numbers. Please help, thanks.
>
>
Bookmarks