pcarmour
11-28-2013, 05:40 AM
Hi,
I have a block of data that I want to find the Value "ISA " in Column "A" and return the values from Column "E" and "B".
On some days there can be multiple matches.
On the attached the results required are in B138:C142
I can't get Vlookup to work with multiple returns.
As always any help is very much appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)
Please see attached.
10878
I have a block of data that I want to find the Value "ISA " in Column "A" and return the values from Column "E" and "B".
On some days there can be multiple matches.
On the attached the results required are in B138:C142
I can't get Vlookup to work with multiple returns.
As always any help is very much appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)
Please see attached.
10878