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)

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