Sheet A contains a large (16000 rows, 8 columns) array of data and Sheet
B a single column which lists certain text values also found in column
1 of Sheet A. The values listed in Sheet B can appear multiple times
in the array in Sheet A.

I want to return from Sheet A the column 8 value (numeric)
corresponding to each occurance of the Sheet B values in column 1 of
Sheet A

The limit of my knowledge in VLOOKUP, but that of course will only
return one Sheet A value from each occurance of the values listed in
Sheet B.

I hope that makes sense, please can somebody help?

Many thanks


--
alexdwsn
------------------------------------------------------------------------
alexdwsn's Profile: http://www.excelforum.com/member.php...o&userid=35241
View this thread: http://www.excelforum.com/showthread...hreadid=550153