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.

Who is Participating?
Rory ArchibaldCommented:
LOOKUP requires the lookup column to be sorted ascending. You can use VLOOKUP:
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,

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.