Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

help with IF statements

  Asked By: Kent    Date: Oct 15    Category: MS Office    Views: 532
  

Need a value in cell e4 to be one of the values in column b the row
will be determined by matching cell c4 to column a using between or
greater than and less than.

a b c
1 800 5
2 1050 5.4
3 1100 5.75
4 1150 5.85 950 cell e4____
5 1200 9
6 1250 9.1
7 1300 9.25
8 1350 9.5
9 1400 10

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Gilberto Thompson     Answered On: Oct 15

Look at VLookUp. It's default mode is a range test. But you'll need to
swap columns B and C. VLookUp does its test in the left column  of the area
it's checking.

You could also use SumProduct, but I think VLookUp is good enough for this.

 
Didn't find what you were looking for? Find more on help with IF statements Or get search suggestion and latest updates.




Tagged: