how to lookup range of data in one cell

[eing]

Hi, I need some help on how to lookup some of my "range of data" in one cell..
please have a look at my sample workbook..Book.xlsx
Thank you very much..

[eing]

So, can you tell me what's your suggestion for this please..?

[popipipo]

Does this help you?

[eing]

This works great for me..!
Thank you so much for the help..
But, why should I use "1" on the [range_lookup] part instead true or false..?
will you explain it please..?

[popipipo]

You can use both:
True = 1
False = 0
I always use 0 and 1 , but that is a personal preference

[eing]

Now I know what the "true" statement for in this formula..
Thank you for your help..

[Ace_XL]

With popipipo's example you could simply use

=LOOKUP(E2,A2:B5)