array as lookup values

Hi,

im really in need to solve this problem:

is it possible to use a range of cells as the lookup value?...

=VLOOKUP(lookup_value,array,false)
where:
lookup_value = single cell, like (A1)
array = range of cells (b1:b30)

now i want it to do in reverse...like

=VLOOKUP(lookup_value,array,false)
lookup_value=RANGE OF CELLS (B1:B30)
array = SINGLE CELL, LIKE(A1)

=vlookup(b1:b30,a1,1,false)

is this possible?

note: the vlookup will not return the EXACT match on the cell but instead IT WILL RETURN ONLY THE ONES THA T MATCHED THE CONTENTS OF THE LOOKUPVALUE.

please see attached for details.

thanks so much