SOLVED

vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-718211%22%20slang%3D%22en-US%22%3Evlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718211%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20creating%20a%20formula%20that%20will%20search%202%20columns%20and%20determine%20when%20an%20input%20value%20is%20%26gt%3B%3D%20column%20A%20and%20%3D%26lt%3B%20Column%20B%20and%20returns%20Column%20C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-718211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evlookup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718401%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718401%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365812%22%20target%3D%22_blank%22%3E%40BowlingAlleyBob%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20provide%20a%20sample%20of%20your%20list%3F%20This%20will%20help%20me%20create%20an%20exact%20formula%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718408%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718408%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365812%22%20target%3D%22_blank%22%3E%40BowlingAlleyBob%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20depends%20on%20your%20data%20setup.%3C%2FP%3E%3CP%3EIt%20could%20be%3A%3C%2FP%3E%3CPRE%3E%3DLOOKUP(E1%2C%24A%241%3A%24A%2410%2C%24C%241%3A%24C%2410)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718513%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20...%20that%20worked%20perfectly...%20made%20me%20feel%20like%20an%20idiot.%26nbsp%3B%20I%20was%20trying%20vlookup%20and%20if%20and%20all%20kinds%20of%20**bleep**...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
BowlingAlleyBob
New Contributor

I need help creating a formula that will search 2 columns and determine when an input value is >= column A and =< Column B and returns Column C

3 Replies

Hello @BowlingAlleyBob,

 

Can you provide a sample of your list? This will help me create an exact formula for you.

 

Thank you!

Solution

@BowlingAlleyBob 

It depends on your data setup.

It could be:

=LOOKUP(E1,$A$1:$A$10,$C$1:$C$10)

@Detlef Lewin 

Thank you ... that worked perfectly... made me feel like an idiot.  I was trying vlookup and if and all kinds of **bleep**... 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies