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