Hi everybody,

I am trying to find a formula which will act as a vlookup but returning multiple values.

As per the attached sheet, I would like a formula in col G which looks up job titles in col F from col A, and returns all names matching that title in col B.

I hope this makes sense, I have been at this for a while, trying to adapt formulae I have found online but to no avail. I am fairly comfortable with array formulae so that should be fine.

Many thanks in advance.

RichARRAY formula file.xlsx