Forum Discussion

BowlingAlleyBob

Copper Contributor

Jun 24, 2019

Solved

vlookup

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

Detlef_Lewin
Jun 24, 2019
BowlingAlleyBob
It depends on your data setup.
It could be:
=LOOKUP(E1,$A$1:$A$10,$C$1:$C$10)

3 Replies

Detlef_Lewin
Silver Contributor
Jun 24, 2019
BowlingAlleyBob
It depends on your data setup.
It could be:
=LOOKUP(E1,$A$1:$A$10,$C$1:$C$10)
- BowlingAlleyBob
  Copper Contributor
  Jun 24, 2019
  Detlef_Lewin
  Thank you ... that worked perfectly... made me feel like an idiot. I was trying vlookup and if and all kinds of **bleep**...
PReagan
Bronze Contributor
Jun 24, 2019
Hello BowlingAlleyBob,

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

Thank you!

Resources