SOLVED

vlookup

Copper 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!

best response confirmed by BowlingAlleyBob (Copper Contributor)
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**... 

 

1 best response

Accepted Solutions
best response confirmed by BowlingAlleyBob (Copper Contributor)
Solution

@BowlingAlleyBob 

It depends on your data setup.

It could be:

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

View solution in original post