Hi,

I would like to lookup a range of values rather than one particular value.

I have a table somewhat similar to this:
1 bob
2 sam
3 jim
4 bill
5 ned

I would like to lookup all results within a range
like vlookup(AND(OR(2,=2),OR(<4,=4)),A1:B5,2) (this unfortunately won't
work)
The resulting values would need to be displayed as:
"sam
jim
bill"
preferrably or;
sam, jim, bill,
would be OK as long as I can do AVERAGE(result) and similar functions if the
returned values were numbers.

Preferrably the results could grow if needed so that:
1<=lookup value<=3 or
2<=lookup value<=5
would both give good results.

Is this possible. If so how.
Thanks in advance for your help,
BudW