Lookup when value is between 2 columns
If column 1 is in E2 and Col 2 is F2 Col 3 =
=IF(OR(E2<=$G$1,F2<=$G$1),"Yes","No")
For column 4 I used
=(INT(MAX(E2:F2)/$G$1)+1)*10
G1 is the number to divide by.
HTH
Peter
"Yegod" wrote:
Hi,
I need to lookup a column if the value is between the first 2 columns
Col 1 Col2 Col3 Col 4
1 5 Yes 10
6 10 Yes 20
11 15 No 30
If the value I am looking up is 7, I need to return Yes from Col 3. So if
value is between col 1 and col 2, return Col 3. I was able to get Col 4 using
Sum (if..) but do not know how to return the text in Col 3
Thanks in advance..
|