vlookup range

  • Thread starter Thread starter norika
  • Start date Start date
N

norika

Hi,

I have a vlookup problem. I need to construct a table to mak
reference, vlookup table is good. But my criterias are rathe
complicated, at least for me.

Range Factor
$0 < x < 19747 100%
$19748 < x < 21012 96%
$21013 < x < 23101 92%

and so on

$49,578 < x 52737 2%
$52737 < x 0%

How to construct the vlookup table to satisfy it or any other formul
or idea?

Thank in advance

norik
 
Hi
just put your loewer range in a separate column. e.g.
A B C
1 0 19747 100%
2 19748 21012 96%
....

if your lookup criteria is in cell E1 use VLOOKUP as follows
=VLOOKUP(E1,A1:C20,3)
 
Back
Top