Jun 24 2019 12:48 PM
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
Jun 24 2019 01:37 PM
Hello @BowlingAlleyBob,
Can you provide a sample of your list? This will help me create an exact formula for you.
Thank you!
Jun 24 2019 01:40 PM
SolutionJun 24 2019 02:40 PM
Thank you ... that worked perfectly... made me feel like an idiot. I was trying vlookup and if and all kinds of **bleep**...
Jun 24 2019 01:40 PM
SolutionIt depends on your data setup.
It could be:
=LOOKUP(E1,$A$1:$A$10,$C$1:$C$10)