Hi all,

I'm a little bit stuck with something - hope you can help.

Is there a custom formula that can be created (or even just an excel formula) to do the equivalent of an index match but return all values that meet the criteria, rather than just the first instance? I have the lookup value in A1, the lookup range is P4:P1000 and the return range is J4:J1000.

Thanks for your anticipated help.