Simple Lookup Formula

EE Pros,

How do I get a selection to compare and select a condition and then show the value.  Seems rather simple.

Appreciate the help.

B.
D--temp-Lookup.xlsm
Bright01Asked:
Who is Participating?
 
Rory ArchibaldCommented:
LOOKUP requires the lookup column to be sorted ascending. You can use VLOOKUP:
=VLOOKUP(E4,D5:E9,2,FALSE)
0
 
Bright01Author Commented:
RORY,  Thank you for showing me how this works...... And it works perfectly!

I will be posting some more "challenging" questions today..... hope you will jump in.

Thanks again,

B.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.