Excel Lookup Problem

[mri777]

I've been working on a tool for a client and am having problems tryin
to figure out how to search a range of numbers on a differen
worksheet. On worksheet "Calculator" I'm using cells I2 and I3 base
on the number in I1. I need I2 to link to worksheet "Weighting Value,
and I3 to link to worksheet "Ballast Value." My problem is bot
worksheets have a low and high range for several "Weighting Values" an
"Balast Values." I need I2 and I3 to each search the desired workshee
and return the Weighting Value or Ballast Value ranges that correspon
to the number in I1. Unfortunately my workbook is too large to attach
An example of the Weighting Data Worksheet is below:

A B C D
Eff. Date Low Value High Value Weighting Value
Jan. 01 0 790 004
Jan. 01 791 1009 007

In this example, I need cell I2 on my primary worksheet to search th
range in B and C and return the corresponding value in D. Any help i
greatly appreciated

 

[Dave Peterson]

Lots of people wouldn't take a chance on opening your workbook anyway. It's
better that you described your problem in plain text.

Wouldn't =vlookup() work for you?

If you put False as the 4th argument, you'd have trouble--it'd look for an exact
match.

But if you use True (or omit it completely), it looks like you could just use
column B as your key:

=vlookup(xxx,sheet2!b:d,3)

Or did I miss something?

 

[mri777]

Dave:

Wow, so simple! I've plugged the formula in and it appears to work.
I'll test it just to be sure. Thanks!!