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

wow! perfect!

thanks so much!...i've been working on this for the past few days and its only now that i was able to get the exact formula...thanks so much for this great help!

by the way, can you check what's wrong with this one?...because this is returning a #REF! result.

Please Login or Register  to view this content.

im not deleting anything on my worksheet.i just change sa cell range.

hi,

thanks so much!...it much clearer now...

i know this is excel forum, but i still want to try to ask if i can apply this formula to access?....because i need to setup a database that works like this

thanks so much!!!