Lookup value where I have two conditions to meet

%3CLINGO-SUB%20id%3D%22lingo-sub-2099850%22%20slang%3D%22en-US%22%3ELookup%20value%20where%20I%20have%20two%20conditions%20to%20meet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099850%22%20slang%3D%22en-US%22%3EI%20need%20to%20look%20up%20a%20value%20in%20a%20range%20where%20I%20need%20to%20check%20that%20the%20values%20in%20the%20first%20two%20columns%20of%20each%20row%20where%20my%20look%20up%20value%20is%20greater%20than%20our%20equal%20to%20the%20value%20in%20column%20one%20and%20less%20than%20the%20value%20in%20column%20two.%20I%20wanted%20to%20use%20vlookup%20but%20couldn%E2%80%99t%20figure%20out%20how%20to%20use%20two%20columns%20for%20the%20look%20up.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2099850%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099932%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20value%20where%20I%20have%20two%20conditions%20to%20meet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099932%22%20slang%3D%22en-US%22%3EMy%20table%20looks%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3ELower%20Range%3A%20Upper%20Range%3A%20Value%3CBR%20%2F%3E0.000000%3A0.000001%3A1%3CBR%20%2F%3E0.000001%3A0.000011%3A2%3CBR%20%2F%3E0.000011%3A0.000111%3A3%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20lookup%20value%20can%20be%20greater%20than%20our%20equal%20to%20the%20lower%20range%20and%20less%20than%20the%20upper%20range.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2100780%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20value%20where%20I%20have%20two%20conditions%20to%20meet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2100780%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F943846%22%20target%3D%22_blank%22%3E%40kumop%3C%2FA%3E%26nbsp%3BPlease%20see%20the%20attached%20example.%20You%20can%20use%20LOOKUP%20or%20XLOOKUP%20for%20this.%20The%20latter%20function%20will%20not%20work%20if%20you%20are%20not%20on%20a%20recent%20Excel%20version.%20The%20first%20will%20work%20on%20all%20versions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I need to look up a value in a range where I need to check that the values in the first two columns of each row where my look up value is greater than our equal to the value in column one and less than the value in column two. I wanted to use vlookup but couldn’t figure out how to use two columns for the look up.
2 Replies
My table looks like this:

Lower Range: Upper Range: Value
0.000000:0.000001:1
0.000001:0.000011:2
0.000011:0.000111:3

My lookup value can be greater than our equal to the lower range and less than the upper range.

@kumop Please see the attached example. You can use LOOKUP or XLOOKUP for this. The latter function will not work if you are not on a recent Excel version. The first will work on all versions.