Lookup Function?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Want to know if there is a function to do what I need. I
have a simple table.

1000 1999 $20
2000 2999 $30
3000 3999 $40

So I want to lookup a number. If it is in the first range
(1000-1999) then return a value of $20, and so forth. I
know how to do this with multiple if then statements, but
can only go 7 levels. This is a simplified example. I
figured there has to be an easier way with a function to
look this up. Any ideas? Thanks.
 
Hi
try
=VLOOKUP(D1,$A$1:$C$1000,3,1)

where D1 stores your lookup value and col. A - col C our example data
from below
 
Hey, Thanks. I use vlookups all the time, but use False at
the end because I need an exact value. I'm assuming a 1 is
just like putting TRUE, and I really don't even need the
second column of numbers since it only looks at the first
column.
 
Hi Mike
a 'Yes' to all of your assumptions .-)
- '1' -> could be replaced by TRUE
- and yes, the second column is not required
 
Back
Top