Hi
Please could someone advise on how to do a lookup that will return multiple answers.
Please see attached Spread.
Sheet 1 lists the lookup Values
Sheet 2 contains the array.
I need to look up all the values against A and return them all in one cell
Against A there is the following, so I would want all 9 returned
Retail
Res
Les
Retail
Pub
Arg
Retail
Res
Les
Is this possible?
cheers
Keith
Bookmarks