I am getting all of my "ifs", "ands" & "Vlookups" real confused on this one.

Any help is appreciated.

Here is what I would like to be able to do in J20 in sentence format:

[1] Find the value of H20 in A2:A11 (it will always be one of these values)

and use that row in the following

[2] If I20 >= value of Column C in the row found, Return "Superior" else

[3] IF I20 >= value of Column B in the row found, Return "Minimum" else

[4] Return "Remediate"

A B C

1 Min Sup

2 11 38 48

3 12 29 39

4 13 23 33

5 14 20 30

6 15 19 29

7 21 18 23

8 22 11 16

9 23 5 10

10 24 5 10

11 25 5 10

I hope my explanation makes sense. My head hurts. Thanks

On Feb 8, 3:34 pm, Bigfoot17 < XXXX@XXXXX.COM >

This should do the trick:

=IF(I20>=VLOOKUP(H20,A:C,3,FALSE),"Superior",IF(I20>=VLOOKUP(H20,A:C,

2,FALSE),"Minimum","Remediate"))

Cheers,

Jason Lepack

This should do the trick:

=IF(I20>=VLOOKUP(H20,A:C,3,FALSE),"Superior",IF(I20>=VLOOKUP(H20,A:C,

2,FALSE),"Minimum","Remediate"))

Cheers,

Jason Lepack

Not any shorter, but just another way to look at it

=CHOOSE(SUMPRODUCT(--(I20>=VLOOKUP(H20,A:C,{2,3},FALSE)))+1,"Remediate","Minimum","Superior")

=CHOOSE(SUMPRODUCT(--(I20>=VLOOKUP(H20,A:C,{2,3},FALSE)))+1,"Remediate","Minimum","Superior")

Ya gotta love this group! It took me longer to write the question than to

get the response! Thanks.

get the response! Thanks.

1. Nesting IF's and AND's - a bit of help please...

2. IF's & AND's

3. two questions: and's inside if's and checking the return code of a program

4. New IFS interface (jfs.ifs, udf.ifs for example)

5. IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP(

7. Multiple Ifs, can't use vlookup

11. Nested IF's and VLookup Tables

13. Vlookups, IF's..and Oh No!

14. nested ifs or vlookup or ?

15. Small (JFS.IFS or HPFS.IFS AutoCheck) install bump, Solved!

4 post • Page:**1** of **1**